var memberSearchs = from m in _member
join t in _balance
on m.MemberName equals t.Owner
into temp
from t in temp.DefaultIfEmpty()
join b in _withDrawLog
on m.MemberName equals b.MemeberName
into temp1
from b in temp1.DefaultIfEmpty()
join v in _userLog
on m.MemberName equals v.Operater
into temp2
from v in temp2.DefaultIfEmpty()
select new
{
m.MemberName,
m.Email,
m.VerifyPhoneNumber,
m.RegisterTime,
m.Country,
m.Channel,
m.DefaultCurrency,
t.Total
};
linq to sql左链接
最新推荐文章于 2021-12-28 16:28:06 发布