c# - Will linq bring back all records from a stored procedure call, and then filter? -


given ef linq below, records in stored proc usp_gettestrecords() come across , filtered?

    testrecordsdbentities datacontext = new testrecordsdbentities();     var tests = datacontext.usp_gettestrecords();     var filtered = tests.where(x => x.groupid == groupid)         .orderbydescending(y => y.name)         .tolist(); 

yes data first fetched in memory , filtered on client side. using stored procedure ef not idea. loose advantage of lazy,eager or explicit loading here. if let ef generate queries compiled filters , executed on server


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -