linq join 的lamada写法 好东西要分享

var query = _db.Bank_CommercialOpus

.Join(_db.Bank_Opus, s => s.OpusID, Opus => Opus.ID, (s, Opus) => new { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, Oupsname = Opus.OpTitle, AddTime = s.AddTime, IsDelete = s.IsDelete })

.Where(s => s.IsDelete == false)

.Select(s => new Bank_CommercialOpus { ID = s.ID, CompanyName = s.CompanyName, ChannelAddress = s.ChannelAddress, CpAddress = s.CpAddress, OpusID = s.OpusID, Oupsname = s.Oupsname, AddTime = s.AddTime, IsDelete = s.IsDelete }).OrderBy(s => s.AddTime);

原文出自 http://www.cnblogs.com/fumj/p/3653014.html