Sunday, February 1, 2009

Left Outer Join in LINQ

var result = from accountDetails in context.AccountDetails
join payment in context.PaymentDetails
on accountDetails.AccountID equals payment.AccountID into temp
from resultDetails in temp.DefaultIfEmpty()
select new { temp.PayeeName,temp.AccountType };

0 comments:

Post a Comment