Creating the data model
To use LINQ to Entities, we need to add a conceptual data model—EDM—to the project. There are two ways to create the EDM—create from a database or create manually. Here we will create the EDM from the
Northwind database. We will add two tables and one view from the
Northwind database into our project so that later on we can use them to demonstrate LINQ to Entities.
Adding a LINQ to Entities item to the project
To start with, let's add a new
item to our test project
TestLINQToEntitiesApp. The new item added should be the ADO.NET Entity Data Model type and named
Northwind.edmx, as shown in the following Add New Item dialog window:
After you click on the Add button, the Entity Data Model Wizard window will pop up. Follow these ...