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 ...

Get WCF 4.5 Multi-Layer Services Development with Entity Framework now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.