现在的位置: 首页 > 综合 > 正文

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

2018年06月10日 ⁄ 综合 ⁄ 共 551字 ⁄ 字号 评论关闭
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

抱歉!评论已关闭.