linq to sql左链接

最新推荐文章于 2024-07-19 09:44:25 发布

原创最新推荐文章于 2024-07-19 09:44:25 发布 · 970 阅读

0 ·

CC 4.0 BY-SA版权

C# 专栏收录该内容

92 篇文章

订阅专栏

本文通过一段LINQ查询代码示例展示了如何从多个表中联合查询成员的基础信息及关联余额、提现记录等详细数据。该示例适用于理解复杂的数据库查询逻辑。

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