title: Does first iteration over .AsEnumerable execute the entire query?
body: <p>If i've got a linq to sql var (eg: var x = from y in db.Orders ....)
  and than i call .AsEnumerable() over that, if i iterate over this elements,
  Does the first iteration execute the ENTIRE query? or are parts of them generated in the foreach loop?</p>