在 LinQ 语句中实现 Left Join 操作
星期四, 09月 18, 2008 10:23Posted in category 技术
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 });
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.