LINQ to SQL and EF both create SQL statements, and pretty darn good ones.

>Neither is SQL ;-) I meant the query method/language as in screwdriver vs. hammer.
>
>>As for local cursors, there are times when they are useful, but having to pull so much data across the wire to resolve the query is not efficient either.

You can do this in .Net too.

>
>Yes, but you can also remember already sent over pages via caching or
>cache and query with timestamp info, thereby lessening data transfer.
>Rowversion info or atomic timestamps are good ;-)