第一次用到linq链接查询,mark一下;
cms.MemberShipId是MemberShip的主键ID
var list = from ms in dbContext.MemberShip
join cms in dbContext.CustomerMemberShipon new { aa = ms.Id, bb = customerId } equals new { aa = cms.MemberShipId, bb = cms.CustomerId }
into shipList
from cms in shipList.DefaultIfEmpty()
select new MemberShipInfo(){Id = ms.Id};