ADO.NET Entity Framework Query Samples

UPDATED WIKI: Home

jkowalski — Mon, 11 Aug 2008 23:46:48 GMT

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.

The project supports querying multiple backends. Included are:

SQL Server 2000 using SqlClient
SQL Server 2005 using SqlClient
SQL Server 2008 using SqlClient
SQL Server Compact 3.5 SP1
EFSampleProvider http://code.msdn.microsoft.com/EFSampleProvider
EFOracleProvider http://code.msdn.microsoft.com/EFOracleProvider

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

UPDATED WIKI: Home

jkowalski — Mon, 11 Aug 2008 23:45:25 GMT

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.

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

CREATED RELEASE: EFQuerySamples for VS2008 SP1 (Aug 11, 2008)

Mon, 11 Aug 2008 18:25:35 GMT

NEW POST: View the model in visual designer

divega — Sun, 18 May 2008 06:05:28 GMT

miksh wrote:
Great samples, thanks. I wonder, how to view the NW entity model in the VS Entity visual designer?

Thanks for your question.

The model the current version of the samples uses includes some advanced features that are available in the Entity Framework runtime, but not in the EDM Designer. That is the reason we don't include an EDMX file that you can open and visualize with the designer tools.

We are looking into how much we need to simplify the model in order to keep almost the same samples queries.

-Diego

UPDATED WIKI: Home

divega — Sun, 18 May 2008 05:56:32 GMT

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.

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

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:53:58 GMT

This release contains query samples that are compatible with the .NET 3.5 SP1 Beta version of Entity Framework.

See [url:Refresh 1|ProjectReleases.aspx?ProjectName=EFQuerySamples&ReleaseId=1032] release for the current version.

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:53:40 GMT

This release contains query samples that are compatible with the .NET 3.5 SP1 Beta version of Entity Framework.

See the [url:Refresh 1|ProjectReleases.aspx?ProjectName=EFQuerySamples&ReleaseId=1032] release for the current version.

UPDATED RELEASE: NETFX 3.5 SP1 Beta Refresh 1 (May 17, 2008)

Sun, 18 May 2008 05:50:29 GMT

This release fixes the NorthwindEF database, which was missing referential constraints in the previous version of the samples.
It also includes some corrections in the grouping of samples.

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:49:23 GMT

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:47:49 GMT

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:44:47 GMT

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 05:40:42 GMT

This release contains query samples that are compatible with the .NET 3.5 SP1 Beta version of Entity Framework.

This version of the sample code is no longer available. See the [url:Refresh 1|ProjectReleases.aspx?ProjectName=EFQuerySamples&ReleaseId=1032] release.

UPDATED RELEASE: NETFX 3.5 SP1 Beta Refresh 1 (May 17, 2008)

Sun, 18 May 2008 05:39:05 GMT

This release fixes the NorthwindEF database, which was missing referential constraints in the previous version of the samples.
It also includes some corrections in the grouping of samples.

UPDATED RELEASE: NETFX 3.5 SP1 Beta (May 13, 2008)

Sun, 18 May 2008 04:04:03 GMT

This release contains query samples that are compatible with the .NET 3.5 SP1 Beta version of Entity Framework.

This version of the sample code is no longer available. See the Refresh 1 release.

UPDATED RELEASE: NETFX 3.5 SP1 Beta Refresh 1 (May 17, 2008)

Sun, 18 May 2008 04:02:42 GMT

This release fixes the NorthwindEF database, which was missing referential constraints in the first release for .NET 3.5 SP1 Beta.
It also includes some fit & finish adjusts in the grouping of samples.

UPDATED RELEASE: .NET 3.5 SP1 Beta Refresh 1 (May 17, 2008)

Sun, 18 May 2008 04:02:24 GMT

CREATED RELEASE: .NET 3.5 Beta Refresh 1 (May 17, 2008)

Sun, 18 May 2008 04:01:30 GMT

NEW POST: View the model in visual designer

miksh — Fri, 16 May 2008 17:39:42 GMT

Great samples, thanks. I wonder, how to view the NW entity model in the VS Entity visual designer?

UPDATED WIKI: Home

divega — Wed, 14 May 2008 01:12:11 GMT

Resource Page Description
ADO.NET Entity Framework Query Samples is a small Windows Forms program that contains several basic Entity SQL and LINQ to Entities queries against that NorthwindEF Entity Data Model (based on a modified version of Northwind).

Its goal is to help you learn the features of the different query languages, visualize how results look like, and also give you some understanding of how the translated store queries look like.

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

UPDATED WIKI: Home

divega — Wed, 14 May 2008 01:11:47 GMT