there is an sql query generated in the background. it may be as complex as required to only fetch the relevant data.

if a query cannot be generated because certain linq features are not supported against a database, then the whole expression will not be compiled (to sql). you can override this behaviour manually if you want to fetch all data and then filter in a complex way on the client side. to do that, you place .tolist() or .toarray() at some early point of your linq query, and carry on where'ing that list.

you can also view the resulting sql.

more reading: linq to sql queries.

Related Query

More Query from same tag