ADO.NET Entity Framework Query Samples

NEW POST: Updated release posted for VS2010 Beta2

edett — Mon, 23 Nov 2009 21:30:06 GMT

The EFQuerySamples for VS2010 Beta2 release includes the following updates

Added several model defined functions to the conceptual model
Extended the ObjectContext to expose model defined functions in Linq to Entities
Added additional query samples for the following areas:

Calling user defined functions in Entity SQL
Using GroupPartition in Entity SQL
OrderBy lifting in Linq to Entities queries
Using Contains (on sequences) in Linq to Entities queries
Calling functions in Linq to Entities queries

Replaced the MDF file with a .sql script to create and populate the NorthwindEF database. This script supports SQL Server 2000, where the MDF only worked on later versions of SQL Server.
Updated the project files for VS 2010 Beta2.

UPDATED WIKI: Home

edett — Mon, 23 Nov 2009 21:00:54 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.

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

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

CREATED RELEASE: EFQuerySamples for VS2010 Beta2 (Nov 23, 2009)

Mon, 23 Nov 2009 20:54:41 GMT

Entity Framework Query Samples are provided in two languages:

C# - EFQuerySamples.zip
VB - EFQuerySamplesVB.zip

NEW POST: How to filter data using EDM

qasimali84 — Thu, 11 Jun 2009 11:42:20 GMT

I have three tables
1. Department
2. Course
3. Version

EDM result it into three entities

1. Departmnet
Properties(Id, Name)
Navigations(Courses)

2. Course
Properties(Id, Name)
Navigations(Department, Versions)

3. Version
Properties(Id, Name, Number)
Navigations(Course)

One Department may have many courses, one course may have many versions

I want to get Latest version of each course by Department ID

My code return me all version of each course by department id

private void BindGrid(GridView Grid, Guid CategoryID)
{
DataEntities data = new DataEntities();
Category cat = (from c in data.Categorys where c.ID == CategoryID select c).First();
IList<Definition> defintions = (from d in data.Definitions.Include("Versions") where d.Category.ID == cat.ID select d).ToList();
IList<DynamicForms.Data.Version> versions;
if (defintions.Count>0)
{
versions = defintions.SelectMany(d=>d.Versions).ToList();

Grid.DataSource = versions;
Grid.DataBind();
}
}

But I want to get latest version (Max Version.Number) of each course. How can i get it please.

UPDATED WIKI: Home

jkowalski — Thu, 21 May 2009 17:41:15 GMT

UPDATE: Visual Basic version of the sample is now available in the Downloads section.

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 RELEASE: EFQuerySamples for VS2008 SP1 (Aug 11, 2008)

Thu, 21 May 2009 17:38:33 GMT

Entity Framework Query Samples are provided in two languages:

C# - EFQuerySamples.zip
VB - EFQuerySamplesVB.zip

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

Thu, 21 May 2009 17:37:24 GMT

NEW POST: SQLite Support for EFQuerySamples

rmsimpson — Fri, 05 Sep 2008 23:11:45 GMT

The modifications made to the 8/11/2008 release of EFQuerySamples to support the SQLite EF provider can be found here:
http://sqlite.phxsoftware.com/forums/p/1377/5921.aspx#5921

Changes consist of a SQLite northwindEF.db database, a new ssdl file, and the necessary hookups to App.Config.

UPDATED WIKI: Home

jkowalski — Tue, 12 Aug 2008 02:46:48 GMT

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 — Tue, 12 Aug 2008 02:45:25 GMT

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

Mon, 11 Aug 2008 21:25:35 GMT

NEW POST: View the model in visual designer

divega — Sun, 18 May 2008 09: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 08:56:32 GMT

NEW POST: View the model in visual designer

miksh — Fri, 16 May 2008 20: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 04: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 04:11:47 GMT

UPDATED WIKI: Home

divega — Wed, 14 May 2008 03:51:32 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 understanding on how the translated store queries look like.