Are these queries doing the same thing

[desanti]

Hello ! I'm using Entity Framework 6 with sql server 2008r2 database. I want to get from database only those records that have vl1>5.( i need to get from database only those objects that have vl1>5 and not to read all the objects and after to apply the condition ) I have 2 queries :

Dim query1 as IeQueryable(of myobj)= (From t in context.myobjs Where vl1<5).Tolist

Dim query2= (From t in context.myobjs.Asqueryable Where vl1<5).Tolist

Are these queries doing the same job that i want ?

[Lost User]

What happens when you try them?

[Lost User]

desanti wrote:

and not to read all the objects and after to apply the condition )

Then use an SQL query and execute your statement on the server, instead of using an ORM. The only difference between the first and second version is the "Asqueryable" part in the second statement; that statement has nothing to do with "where" the query executes. So, to answer, yes, they're doing the same job. Not sure if it's what you want though.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.