Code: Select all
_elementRepository.Query()
.Where(x => x.JOB_ID == job.G3E_IDENTIFIER)
.GroupBy(x => new { x.G3E_FID, x.LTT_ID })
.Select(x => new { Fid = x.Key.G3E_FID, LttId = x.Key.LTT_ID, MaxLttTid = x.Max(j => j.LTT_TID)});
Code: Select all
SELECT
"GroupBy1".K1 AS G3E_FID,
"GroupBy1".K2 AS LTT_ID,
"GroupBy1".A1 AS C1
FROM ( SELECT "Extent1".G3E_FID AS K1, "Extent1".LTT_ID AS K2, Max("Extent1".LTT_TID) AS A1
FROM GCOMM."B$GC_NETELEM" "Extent1"
WHERE (("Extent1".JOB_ID = :p__linq__0) AND ( NOT (("Extent1".JOB_ID IS NULL) OR (:p__linq__0 IS NULL)))) OR (("Extent1".JOB_ID IS NULL) AND (:p__linq__0 IS NULL))
GROUP BY "Extent1".G3E_FID, "Extent1".LTT_ID
) "GroupBy1"
/*
String p__linq__0 = "391758"
*/
Code: Select all
SELECT
"GroupBy1".K1 AS G3E_FID,
"GroupBy1".K2 AS LTT_ID,
"GroupBy1".A1 AS C1
FROM ( SELECT "Extent1".G3E_FID AS K1, "Extent1".LTT_ID AS K2, Max("Extent1".LTT_TID) AS A1
FROM GCOMM."B$GC_NETELEM" "Extent1"
WHERE "Extent1".JOB_ID = :p__linq__0
GROUP BY "Extent1".G3E_FID, "Extent1".LTT_ID
) "GroupBy1"
/*
String p__linq__0 = "391758"
*/
Code: Select all
OR (("Extent1".JOB_ID IS NULL) AND ('391758' IS NULL))