Posts Tagged ‘LinQ’
在 LinQ 语句中实现 Left Join 操作 »
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 });