Sending LINQ Query to Entity Framework as string

Question

How I can send a linq query as string to Entity Framework for example:

from s in students select s

I want to compile this in oracle and sql server

Entity Sql is designed for this sort of thing, linq to entities would mean you have to execute dynamic code, which is nasty to say the least. — JonVD
– JonVD, Commented Nov 22, 2010 at 11:13

Botz3000 · Accepted Answer · 2010-11-22 11:20:26Z

6

You might want to have a look at Entity SQL.
Here is an example: http://msdn.microsoft.com/en-us/library/bb738684.aspx

Another possibility is Dynamic LINQ.

edited Nov 22, 2010 at 11:20

answered Nov 22, 2010 at 11:12

Botz3000

39.8k8 gold badges107 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kamiar3001 Over a year ago

Entity Sql gets string command but it is not linq query and it has kind of sql server structure howover I want to compile this in orcal and sql.

Botz3000 Over a year ago

Entity SQL is just as database-independent as normal LINQ, i.e. it gets translated to your Database's native query language, too. However, you can also have a look at Dynamic LINQ (see edit of my answer).

Ali Tarhini · Accepted Answer · 2010-11-22 11:40:59Z

0

i use Dynamic Linq to dynamically construct linq queries at run time

http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

answered Nov 22, 2010 at 11:40

Ali Tarhini

5,3686 gold badges45 silver badges66 bronze badges

1 Comment

kamiar3001 Over a year ago

it seems that it is limited to condition of query but I want to construct the whole of query

Collectives™ on Stack Overflow

Sending LINQ Query to Entity Framework as string

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related