将SQL转换为LINQ（内连接到左外连接）C＃-Java 学习之路

嗨，我正在尝试将下面的SQL转换为LINQ（只学习linq所以请耐心等待）

SELECT SUM(Bt.Stake)AS TotalStake, SUM(Bt.Payout) AS TotalPayout, SUM(Bt.Stake - Bt.BetPayout) AS TotalProfitLoss, COUNT(Bt.BtID) AS NumberBts,
                      EV_MarketMix.Description
            FROM         Bt INNER JOIN
                                  Slip ON Bt.SlipID = Slip.SlipId LEFT OUTER JOIN
                                  EV_MarketMix ON Bt.MarketMixID = EV_MarketMix.MarketMixID
            WHERE(Slip.DateScanned >= @StartDate) AND(Slip.DateScanned < @EndDate)
            GROUP BY EV_MarketMix.Description

我知道如何使用 join in on equals linq格式进行内连接，并且我已经阅读了如何使用 DefaultIfEmpty() 属性执行左外连接，但我不确定如何继续执行内连接，然后是左外连接 . 谁能告诉我如何去那里？任何帮助或指示我正确的方向看起来将不胜感激 .

1 回答

与在SQL中一样，您可以执行内部联接，然后执行另一个左联接

var query = (from t1 in Context.Table1
    join t2 in Context.Table2 on //...  //inner join
    join t3 in Context.Table3 on /*...*/ into joined //left join
    from joined.DefaultIfEmpty()
    select new 
    {
       //....
    };

回复于 2024-04-17T00:30:58+08:00

将SQL转换为LINQ（内连接到左外连接）C＃

1 回答

相关问题