Просьба о помощи в преобразовании SQL-запроса в EF Core [закрыто] ⇐ C#

[Anonymous]

У меня есть работающая программа, которая использует запросы SQL для сбора данных. Я работаю над преобразованием его в EF Core 8.
SELECT
DATEPART(mm, TSTAMP) AS Month,
DATEPART(dd, TSTAMP) AS Day,
DATEPART(hh, TSTAMP) AS Hour,
COUNT(CASE WHEN System = 1 THEN CHANNEL END) "IPAPL 1 Processed",
MAX(CASE WHEN System = 1 THEN [USED] END) AS "IPAPL 1 MaxUsed",
COUNT(CASE WHEN System = 2 THEN CHANNEL END) "IPAPL 2 Processed",
MAX(CASE WHEN System = 2 THEN [USED] END) AS "IPAPL 2 MaxUsed",
COUNT(CASE WHEN System = 3 THEN CHANNEL END) "IPAPL 3 Processed",
MAX(CASE WHEN System = 3 THEN [USED] END) AS "IPAPL 3 MaxUsed",
COUNT(CASE WHEN System = 4 THEN CHANNEL END) "IPAPL 4 Processed",
MAX(CASE WHEN System = 4 THEN [USED] END) AS "IPAPL 4 MaxUsed"
FROM
[Customerdbchannels].[dbo].[TelematicPhysicalLines]
WHERE
TSTAMP >= '2024-04-01'
AND TSTAMP < '2024-07-01'
AND STATUS 'free'
GROUP BY
DATEPART(mm, TSTAMP), DATEPART(dd, TSTAMP), DATEPART(hour, TSTAMP)
ORDER BY
Month, Day, Hour;


Подробнее здесь: https://stackoverflow.com/questions/787 ... to-ef-core