Search Wiki:
ADO.NET Entity Framework Query Samples is a small Windows Forms program which contains several basic Entity SQL and LINQ to Entities queries against that NorthwindEF Entity Data Model (a modified version of Northwind).

Its goal is to help you learn the features of the different query languages available in the Entity Framework, and to let you visualize how the results and the translated store queries look like.

UPDATE: The samples have been updated for VS 2010 RTM.


The project supports querying multiple backends. Included are:


EFQuerySamples.jpg

Previous versions of these samples can be found at CodePlex.com

Last edited May 27 2010 at 8:34 PM  by JonathanAneja, version 10
Comments
Ewerton wrote  Sep 3 2009 at 8:55 PM  
Awesome, thanks

shunt wrote  Feb 17 2010 at 10:51 PM  
I downloaded this sample and it will not run. The program conversion utility ran and did not convert the program properly. I thought the program had already been converted to VS2010 Beta 2 as it states above. Also, the Northwind EF database is not included in the download!

rkb wrote  Oct 20 2010 at 6:27 PM  
Where do I get tne Northwind EF database?

charleyli wrote  Nov 30 2010 at 7:39 PM  
script to create Northwind EF DB in included inside the zip file under 'DB' directory.

charleyli wrote  Nov 30 2010 at 7:41 PM  
the connection string inside app.config file need to be changed to point to your instance of DB that has NorthwindEF installed.

RavishingRav wrote  Mar 3 2011 at 10:21 AM  
I am getting error with AttachDbFilename=|DataDirectory| in App.config, can someone help me on this.

NewportSolutions wrote  Mar 19 2011 at 7:23 AM  
This is a Fantastic Sample! Regarding database issues. I created a database, did a build and ran the app and was not able to connect. This will get you running in 3 mins: 1) Read the readme.txt 2) Open SQL Server Management Studio and run the EFQuerySamples\DB\CreateNorthwindEFDB.sql script to create a database. 3) Open Server Explorer in VS2010, create a new connection to the new database, right click properties, copy the Connection String property. 4) Open App.Config, modify NorthwindEF (SQL Server 2008) connection string (make a copy first rename copy to orig_NorthwindEF (SQL Server 2008)...), then REPLACE connection string='xxxxxx' with connection string='[paste value from Server Explorer Connection String property]'. 5) Build and run no problem.

Updating...
Page view tracker