系统学习LinQ的开始. 请看这里.
101 LINQ Samples
Reply
系统学习LinQ的开始. 请看这里.
var query = (from p in dc.GetTable<Person>()
join pa in dc.GetTable<PersonAddress>() on p.Id equals pa.PersonId into tempAddresses
from addresses in tempAddresses.DefaultIfEmpty(new PersonAddress())
select new { p.FirstName, p.LastName, addresses.State });