In Visual Studio, open Server Explorer/Database Explorer by clicking Server Explorer/Database Explorer on the View menu.

Right-click Data Connections in Server Explorer/Database Explorer and then click Add Connection.

Specify a valid connection to the Northwind sample database.

In Visual Studio, on the File menu, point to New and then click Project. Select Visual Basic Windows Forms Application as the project type.

On the Project menu, click Add New Item. Select the LINQ to SQL Classes item template.

Name the file northwind.dbml. Click Add. The Object Relational Designer (O/R Designer) opens for the northwind.dbml file.

In Server Explorer/Database Explorer, expand the connection to the Northwind database. Expand the Tables folder.

If you have closed the O/R Designer, you can reopen it by double-clicking the northwind.dbml file that you added earlier.

Click the Customers table and drag it to the left pane of the designer. Click the Orders table and drag it to the left pane of the designer.

The designer creates new Customer and Order objects for your project. Notice that the designer automatically detects relationships between the tables and creates child properties for related objects. For example, IntelliSense will show that the Customer object has an Orders property for all orders related to that customer.

Save your changes and close the designer.

Save your project.

From the Toolbox, drag a DataGridView control onto the default Windows Form for your project, Form1.

Double-click Form1 to add code to the Load event of the form.

When you added tables to the O/R Designer, the designer added a DataContext object for your project. This object contains the code that you must have to access those tables, in addition to individual objects and collections for each table. The DataContext object for your project is named based on the name of your .dbml file. For this project, the DataContext object is named northwindDataContext.

You can create an instance of the DataContext in your code and query the tables specified by the O/R Designer.

Add the following code to the Load event to query the tables that are exposed as properties of your data context. The query filters the results and returns only customers that are located in London.

Dim db As New northwindDataContext

Dim customers_London = From cust In db.Customers 
                       Where cust.City = "London" 
                       Select cust.CustomerID, cust.CompanyName, 
                              OrderCount = cust.Orders.Count, 
                              cust.City, cust.Country

DataGridView1.DataSource = customers_London

Press F5 to run your project and view the results.

Following are some other filters that you can try.

Dim companies_H = From cust In db.Customers 
                  Where cust.Orders.Count > 0 And
                        cust.CompanyName.StartsWith("H") 
                  Select cust.CustomerID, cust.CompanyName, 
                         OrderCount = cust.Orders.Count, 
                         cust.Country

Dim customers_USA = From cust In db.Customers 
                    Where cust.Orders.Count > 15 And
                          cust.Country = "USA" 
                    Select cust.CustomerID, cust.CompanyName, 
                           OrderCount = cust.Orders.Count, 
                           cust.Country