title: Is linq a cursor?
body: <p>I'm familiar with .NET and with SQL.  Now I'm looking at the new LINQ and it looks to me just like a cursor.  I understand the ease of use, etc., but if I do a LINQ-to-SQL query with a foreach loop, am I just using a DB cursor?  Or is there some sort of magic behind the scenes where LINQ collects all the data at once and feeds it to my program one row at a time?</p>