EFQuerySamples Forum Rss Feed

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.

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.

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.

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

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?