Max
Posted: Thu 08 May 2014 10:13
Using latest version of dotConnect for Oracle (8.3.146) and Entity Framework 6.1.
maxHylsplanBana should be (and was in earlier versions) 3, not 1.
Hylsplan contains 4 collections of 3 Hylsplan_Bana.
hylsplan.Max generates this SQL:
Which gives the result
hylsplan.ToList generates this:
Whick gives the result
Where I can see that there is 4 groups of hylsplan with 3 hylsplan_bana
Regards,
Patrik
maxHylsplanBana should be (and was in earlier versions) 3, not 1.
Hylsplan contains 4 collections of 3 Hylsplan_Bana.
hylsplan.Max generates this SQL:
Code: Select all
SELECT
"GroupBy2".A1 AS C1
FROM ( SELECT Max((SELECT Count(1) AS A1
FROM PL.HYLSPLAN_BANA "Extent2"
WHERE ("Extent1".ID = "Extent2".HYLSPLAN_ID) AND ROWNUM <= 1)) AS A1
FROM PL.HYLSPLAN "Extent1"
WHERE ("Extent1".STATUS = 'N') AND ("Extent1".MASKIN_NR = 1)
) "GroupBy2";
C1
1
hylsplan.ToList generates this:
Code: Select all
SELECT
"Project2".C2 AS C1,
"Project2".ID,
"Project2".STATUS,
"Project2".ORDNINGS_NR,
"Project2".KORORDER_NR,
"Project2".KNIVSTALLNING_NR,
"Project2".HYLSKOD,
"Project2".PLANERAT_ANTAL_SET,
"Project2".PRODUCERAT_ANTAL_SET,
"Project2".C3 AS C2,
"Project2".TOLERANS,
"Project2".LANGDJUSTERING,
"Project2".UPD_DATUM,
"Project2".C5 AS C3,
"Project2".MASKIN_NR,
"Project2".HYLSPLAN_NR,
"Project2".BESTALLARE,
"Project2".UTGANGSHYLSA,
"Project2".SKP_DATUM,
"Project2".HYLSKAP_STATUS,
"Project2".C4,
"Project2".HYLSPLAN_ID,
"Project2".BANA_NR,
"Project2".LANGD,
"Project2".PLUGG,
"Project2".SKP_DATUM1,
"Project2".UPD_DATUM1
FROM ( SELECT
CASE WHEN "Project1".STATUS = 'P' THEN 1 ELSE 2 END AS C1,
"Project1".ID,
"Project1".MASKIN_NR,
"Project1".HYLSPLAN_NR,
"Project1".STATUS,
"Project1".BESTALLARE,
"Project1".KORORDER_NR,
"Project1".KNIVSTALLNING_NR,
"Project1".HYLSKOD,
"Project1".UTGANGSHYLSA,
"Project1".TOLERANS,
"Project1".LANGDJUSTERING,
"Project1".PLANERAT_ANTAL_SET,
"Project1".PRODUCERAT_ANTAL_SET,
"Project1".SKP_DATUM,
"Project1".UPD_DATUM,
"Project1".ORDNINGS_NR,
"Project1".HYLSKAP_STATUS,
1 AS C2,
"Project1".PLANERAT_ANTAL_SET - "Project1".PRODUCERAT_ANTAL_SET AS C3,
"Extent3".HYLSPLAN_ID,
"Extent3".BANA_NR,
"Extent3".LANGD,
"Extent3".PLUGG,
"Extent3".SKP_DATUM AS SKP_DATUM1,
"Extent3".UPD_DATUM AS UPD_DATUM1,
CASE WHEN "Extent3".HYLSPLAN_ID IS NULL THEN TO_NUMBER(NULL) ELSE 1 END AS C4,
"Project1".C1 AS C5
FROM (SELECT
"Extent1".ID,
"Extent1".MASKIN_NR,
"Extent1".HYLSPLAN_NR,
"Extent1".STATUS,
"Extent1".BESTALLARE,
"Extent1".KORORDER_NR,
"Extent1".KNIVSTALLNING_NR,
"Extent1".HYLSKOD,
"Extent1".UTGANGSHYLSA,
"Extent1".TOLERANS,
"Extent1".LANGDJUSTERING,
"Extent1".PLANERAT_ANTAL_SET,
"Extent1".PRODUCERAT_ANTAL_SET,
"Extent1".SKP_DATUM,
"Extent1".UPD_DATUM,
"Extent1".ORDNINGS_NR,
"Extent1".HYLSKAP_STATUS,
(SELECT Sum("Extent2".LANGD) AS A1
FROM PL.HYLSPLAN_BANA "Extent2"
WHERE ("Extent1".ID = "Extent2".HYLSPLAN_ID) AND ROWNUM <= 1) AS C1
FROM PL.HYLSPLAN "Extent1"
WHERE ("Extent1".STATUS = 'N') AND ("Extent1".MASKIN_NR = 1) ) "Project1"
LEFT OUTER JOIN PL.HYLSPLAN_BANA "Extent3" ON "Project1".ID = "Extent3".HYLSPLAN_ID
) "Project2"
ORDER BY "Project2".C1 ASC, "Project2".ORDNINGS_NR ASC, "Project2".ID ASC, "Project2".C4 ASC;
Where I can see that there is 4 groups of hylsplan with 3 hylsplan_bana
Regards,
Patrik