Display Records using LINQ

Advantage .NET Data Provider

  Previous topic Next topic  

Display Database Records using LINQ


The following task will display the Customers table in a GridView.


1.Select Data | Show Data Sources.
2.Click Add New Data Source… in the Data Sources window.
3.Select Object click Next.
4.Expand EFDemo and select Customers and click Finish.
5.Double-click Form1.cs from the Solution Explorer Window.
6.Drag the Customers object from the Data Sources window and drop it on Form1.
7.Double click Form1 to open the code editor.
8.In the Load event of the forum add the following code:


                    // Create an ObjectContext instance based on EFDemo.EFDemoEntities
          var ADSEntities = new EFDemo.EFDemoEntities();
          // Retrieve the list of customers using LINQ
          var customers = from c in ADSEntities.Customers
                          orderby c.City
                          select c;
          // Bind the customers object to the data grid
          customersBindingSource.DataSource = customers;


9.  Run the project by pressing F5.  The form will contain the customer’s information ordered by city.



Additional Resources and Tutorials

Microsoft MSDN Entity Framework Getting Started Guide

Microsoft Entity Framework Quickstart


See Also

Entity Framework Quick Start Overview

Create the sample database

Create the Entity Data Model