linq to sql左链接

 

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                                           };