Пример LINQ to SQL

[MOPO3]

Маленький пример LINQ to SQL.

Код:

Customer cust1 = db.Customers.First(c => c.CustomerID == "BONAP");   
Customer cust2 = (
                  from o in db.Orders 
                  where o.Customer.CustomerID == "BONAP"
                  select o
                 ).First().Customer;   

Console.WriteLine("cust1 and cust2 refer to the same object in memory: {0}", Object.ReferenceEquals(cust1, cust2));