i am watching this tutorial. at around 15:40, the speaker said something like a LINQ query won't create a rich collection like BindingListCollectionView
. i am thinking maybe it means changes wont be saved to the database or something. so i tried replacing
var result = database.Customers.Execute(System.Data.Objects.MergeOption.AppendOnly);
with
var result = from cust in database.Customers
where cust.City == "Seattle"
select cust;
and all still works fine.