EAS.NET Linq外连接写法
//1.连接
var v1 = from c in db.FareDetails
from d in db.DrugDetails.Where(o => o.Regcode == c.Regcode)
where c.Id >= 206474 && c.Id <= 206527 && d.Id >= 999700 && d.Id <= 999709
select new
{
RegCode1 = c.Regcode,
Name1 = c.Name,
RegCode2 = d.Regcode,
Name2 = d.Name
};
var v2 = from c in db.FareDetails
from d in db.DrugDetails.Where(d => d.Id >= 999700 && d.Id <= 999709).Where(d => d.Regcode == c.Regcode).DefaultIfEmpty()
where c.Id >= 206474 && c.Id <= 206527
select new
{
RegCode1 = c.Regcode,
Name1 = c.Name,
RegCode2 = d.Regcode,
Name2 = d.Name
};