Using ObjectQuery with Entity Framework

Normally we manipulate the Entity Framework using var like the statements below.

 

BeancurdModel.BeancurdEntities context = new BeancurdModel.BeancurdEntities();
var bc = from b in context.Beancurds select b;

 

We can actually do it without using var. The below statements are using ObjectQuery<T>.

 

string queryString =

            @”SELECT VALUE product FROM AdventureworksEntities.Products AS product”;

 

// Call the constructor with the specified query and the ObjectContext.

ObjectQuery<Product> productQuery2 =

    newObjectQuery<Product>(queryString, context);

 

I have put the following 2 MSDN articles into a sample.

 

1.     ObjectQuery<T> Class

 

2.     ObjectQuery<T>.GroupBy Method

 

Download the sample project fromhttp://skydrive.live.com.The sample file name is ConAppObjectQuery.rar. My MSN ID is chanmmn@hotmail.com.

 

Resources :

Using IEnumerable with LINQ

How to pass var as parameter

Get data from parent-child relationship using edmx

Enumerable.Cast<TResult> Method

 

About these ads

About chanmingman

Ming Man is a senior manager for a development company. With 20 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.
This entry was posted in .Net and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s