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