We switched forums, you can search our old forums HERE

Support Forums

 
ForumForumEntitySpaces AP...EntitySpaces AP...LINQLINQData selection and finltering orderData selection and finltering order
Disabled 
Previous
 
Next Next
New Post
 1/17/2010 12:41 PM
 
tlbignerd
No Ranking

www.tlbignerd.com
Joined: 1/31/2009
Posts: 2

How does database querying take place when using LINQ? Specifically, I'm wondering if I created a LINQ query similar to what would be used in the EntityFramework, does ES create the query with filters, then run it against the database, or are all rows returned from the database, then filtered with LINQ where clauses?
New Post
 1/17/2010 2:26 PM
 
Mike.Griffin
1st Level Poster

Mike.Griffin's Avatar

Mike.Griffin's Avatar

Joined: 6/16/2005
Posts: 1002
 Modified By Mike.Griffin on 1/17/2010 2:29:04 PM

For SQL Server if you use true LINQ queries with EntitySpaces it is really just a true LINQ query, take a look at this post and this shows you the mechanics we use under the hood.

http://www.entityspaces.net/blog/2008...

It is possible to pass a LINQ query down to ADO.NET and get a DataTable back, that is exactly what we do.

Here is how to use true LINQ queries to load your EntitySpaces collections or entities ...

http://www.entityspaces.net/blog/2008...

Also, ES2010 really takes advantage of the newer syntaxes in .NET, our last three blog posts show some of what is coming, see the three preview video's ...

Twitter | BLOG | Vid | Please honor our Software License
 Page 1 of 1
Disabled 
Previous
 
Next Next
ForumForumEntitySpaces AP...EntitySpaces AP...LINQLINQData selection and finltering orderData selection and finltering order

Copyright © 2005 - 2010, EntitySpaces, LLC | Privacy Statement | Terms Of Use