具有固定值的Linq多重连接

sbdsn5lh 于 2023-07-31 发布在其他

关注(0)|答案(1)|浏览(114)

我有以下SQL查询：

select      MFSOAM_SubAccountNbr, MFSOAM_Description, 0 as OK, MFSOAM_SubAccountNbr 
from        MFSOAM 
            left join MFSOA on MFSOA_Account=MFSOAM_SubAccountNbr 
            and MFSOA_Acc='1.1.01' 
where       MFSOA_Acc is null 
order by    OK, MFSOA.MFSOA_Account

字符串
然后我从上面的查询创建一个Linq，类似于：

var model2 = await (from a in _context.Mfsoams
                    join b in _context.Mfsoas on new { a.MfsoamSubAccountNbr } equals new { b.MfsoaAccount, jon = b.MfsoaAcc == request.Account } into ab 
                            from c in ab.DefaultIfEmpty()
                            where c.MfsoaAcc == null
                            select new
                            {
                                Acc = a.MfsoamSubAccountNbr,
                                Desc = a.MfsoamDescription,
                                OK = 0,
                                Acc2 = a.MfsoamSubAccountNbr,
                                Acc3 = c.MfsoaAcc
                            }).OrderBy(o => o.OK).ThenBy(o => o.Acc3).ToListAsync(cancellationToken);

型
但是join单词上有个错误，它说join子句不正确。
请指教。

谢谢-谢谢

linq

来源：https://stackoverflow.com/questions/76608943/linq-multiple-join-with-fix-value

1条答案

按热度按时间

acruukt91#

相等的LHS与联接中相等的RHS的类型不同。
LHS类型为

class LHS
{ 
    int MfsoamSubAccountNbr {get;} 
}

字符串
RHS类型为

class RHS 
{
    int MfsoaAccount { get; }
    bool jon { get; }
}

型
没有明显的方法可以在这两种类型上执行EQUALS。
我猜你想

var query = from a in _context.Mfsoams
         join b in _context.Mfsoas 
         on new { Account = a.MfsoamSubAccountNbr, MfsoaAcc = request.Account } 
         equals new { Account = b.MfsoaAccount, b.MfsoaAcc } into ab 
         from c in ab.DefaultIfEmpty()
         where c.MfsoaAcc == null

型

赞(0）回复(0）举报 2023-07-31

我来回答

具有固定值的Linq多重连接

1条答案

相关问题

热门标签

最新问答