verwendetes Datenbanksystem: <Oracle 10>
Hallo,
Ich benutze Entityframework 4.3 mit oracle und odp.net.
die folgende Abfrage funktioniert in Oracle 11g (als Testumgebung) und bringt den Fehler ORA-01790 Error in 10g(Produktion oder Live Betrieb).
var headers_query = context.PPL_MEA_HEADER_T.Where(h => h.STORAGE_ID == storage.STORAGE_ID)
.Include(h => h.PPL_FIRMWARE_T)
.Include(h => h.PPL_MEA_DATASET_T)
.Include(h => h.PPL_TESTSTEP_T);
der generierte sql Befehl
SELECT
"UnionAll2"."C2" AS "C1",
"UnionAll2"."C3" AS "C2",
"UnionAll2"."C4" AS "C3",
"UnionAll2"."C5" AS "C4",
"UnionAll2"."C6" AS "C5",
"UnionAll2"."C7" AS "C6",
"UnionAll2"."C8" AS "C7",
"UnionAll2"."C9" AS "C8",
"UnionAll2"."C10" AS "C9",
"UnionAll2"."C11" AS "C10",
"UnionAll2"."C12" AS "C11",
"UnionAll2"."C13" AS "C12",
"UnionAll2"."C14" AS "C13",
"UnionAll2"."C15" AS "C14",
"UnionAll2"."C16" AS "C15",
"UnionAll2"."C17" AS "C16",
"UnionAll2"."C18" AS "C17",
"UnionAll2"."C19" AS "C18",
"UnionAll2"."C20" AS "C19",
"UnionAll2"."C21" AS "C20",
"UnionAll2"."C22" AS "C21",
"UnionAll2"."C23" AS "C22",
"UnionAll2"."C24" AS "C23",
"UnionAll2"."C25" AS "C24",
"UnionAll2"."C26" AS "C25",
"UnionAll2"."C27" AS "C26",
"UnionAll2"."C28" AS "C27",
"UnionAll2"."C29" AS "C28",
"UnionAll2"."C30" AS "C29",
"UnionAll2"."C31" AS "C30",
"UnionAll2"."C32" AS "C31",
"UnionAll2"."C33" AS "C32",
"UnionAll2"."C34" AS "C33",
"UnionAll2"."C35" AS "C34",
"UnionAll2"."C36" AS "C35",
"UnionAll2"."C37" AS "C36",
"UnionAll2"."C38" AS "C37",
"UnionAll2"."C39" AS "C38",
"UnionAll2"."C1" AS "C39",
"UnionAll2"."C40" AS "C40",
"UnionAll2"."C41" AS "C41",
"UnionAll2"."C42" AS "C42",
"UnionAll2"."C43" AS "C43",
"UnionAll2"."C44" AS "C44",
"UnionAll2"."C45" AS "C45",
"UnionAll2"."C46" AS "C46",
"UnionAll2"."C47" AS "C47",
"UnionAll2"."C48" AS "C48",
"UnionAll2"."C49" AS "C49",
"UnionAll2"."C50" AS "C50",
"UnionAll2"."C51" AS "C51",
"UnionAll2"."C52" AS "C52",
"UnionAll2"."C53" AS "C53",
"UnionAll2"."C54" AS "C54",
"UnionAll2"."C55" AS "C55",
"UnionAll2"."C56" AS "C56",
"UnionAll2"."C57" AS "C57",
"UnionAll2"."C58" AS "C58",
"UnionAll2"."C59" AS "C59",
"UnionAll2"."C60" AS "C60",
"UnionAll2"."C61" AS "C61",
"UnionAll2"."C62" AS "C62",
"UnionAll2"."C63" AS "C63",
"UnionAll2"."C64" AS "C64",
"UnionAll2"."C65" AS "C65",
"UnionAll2"."C66" AS "C66",
"UnionAll2"."C67" AS "C67",
"UnionAll2"."C68" AS "C68",
"UnionAll2"."C69" AS "C69",
"UnionAll2"."C70" AS "C70",
"UnionAll2"."C71" AS "C71",
"UnionAll2"."C72" AS "C72",
"UnionAll2"."C73" AS "C73",
"UnionAll2"."C74" AS "C74"
FROM (SELECT
"UnionAll1"."C1" AS "C1",
"UnionAll1"."C2" AS "C2",
"UnionAll1"."HEADER_ID" AS "C3",
"UnionAll1"."STORAGE_ID" AS "C4",
"UnionAll1"."TESTSYSTEM" AS "C5",
"UnionAll1"."TESTSYSTEMCALIBNO" AS "C6",
"UnionAll1"."WINATS_VERSION" AS "C7",
"UnionAll1"."PSL_NAME" AS "C8",
"UnionAll1"."TESTDATE" AS "C9",
"UnionAll1"."TESTPROGBASE" AS "C10",
"UnionAll1"."TESTPROGREV" AS "C11",
"UnionAll1"."TESTPROGDATE" AS "C12",
"UnionAll1"."DEVICESERIALNOLIST" AS "C13",
"UnionAll1"."FIXTURENOLIST" AS "C14",
"UnionAll1"."ARRAYLAYOUTX" AS "C15",
"UnionAll1"."ARRAYLAYOUTY" AS "C16",
"UnionAll1"."REMARK1" AS "C17",
"UnionAll1"."REMARK2" AS "C18",
"UnionAll1"."PRODSTATUS" AS "C19",
"UnionAll1"."REPAIRNO" AS "C20",
"UnionAll1"."TESTSTARTMODE" AS "C21",
"UnionAll1"."TESTSTARTSUPERVISOR" AS "C22",
"UnionAll1"."RCI_EDM_SETTING" AS "C23",
"UnionAll1"."RCI_EDM_SUPERVISOR" AS "C24",
"UnionAll1"."RCI_EDM_RELEASEREASON" AS "C25",
"UnionAll1"."RCI_PAR_SETTING" AS "C26",
"UnionAll1"."RCI_PAR_SUPERVISOR" AS "C27",
"UnionAll1"."RCI_PROG_SETTING" AS "C28",
"UnionAll1"."RCI_PROG_SUPERVISOR" AS "C29",
"UnionAll1"."RCI_PPS_SETTING" AS "C30",
"UnionAll1"."RCI_PPS_SUPERVISOR" AS "C31",
"UnionAll1"."OPERATOR_NO" AS "C32",
"UnionAll1"."AMBTEMPERATURELOWERLIMIT" AS "C33",
"UnionAll1"."AMBTEMPERATUREUPPERLIMIT" AS "C34",
"UnionAll1"."AMBHUMIDITYLOWERLIMIT" AS "C35",
"UnionAll1"."AMBHUMIDITYUPPERLIMIT" AS "C36",
"UnionAll1"."ORDERTYPE" AS "C37",
"UnionAll1"."CREATION_DATE" AS "C38",
"UnionAll1"."CHANGE_DATE" AS "C39",
"UnionAll1"."FIRMWARE_ID" AS "C40",
"UnionAll1"."HEADER_ID1" AS "C41",
"UnionAll1"."INDEXNO" AS "C42",
"UnionAll1"."FIRMWARE" AS "C43",
"UnionAll1"."RELEASESTATE" AS "C44",
"UnionAll1"."MOVEXENTRY" AS "C45",
"UnionAll1"."SUPERVISOR" AS "C46",
"UnionAll1"."COMMENTS" AS "C47",
"UnionAll1"."CREATION_DATE1" AS "C48",
"UnionAll1"."CHANGE_DATE1" AS "C49",
"UnionAll1"."C3" AS "C50",
"UnionAll1"."C4" AS "C51",
"UnionAll1"."C5" AS "C52",
"UnionAll1"."C6" AS "C53",
"UnionAll1"."C7" AS "C54",
"UnionAll1"."C8" AS "C55",
"UnionAll1"."C9" AS "C56",
"UnionAll1"."C10" AS "C57",
"UnionAll1"."C11" AS "C58",
"UnionAll1"."C12" AS "C59",
"UnionAll1"."C13" AS "C60",
"UnionAll1"."C14" AS "C61",
"UnionAll1"."C15" AS "C62",
"UnionAll1"."C16" AS "C63",
"UnionAll1"."C17" AS "C64",
"UnionAll1"."C18" AS "C65",
"UnionAll1"."C19" AS "C66",
"UnionAll1"."C20" AS "C67",
"UnionAll1"."C21" AS "C68",
"UnionAll1"."C22" AS "C69",
"UnionAll1"."C23" AS "C70",
"UnionAll1"."C24" AS "C71",
"UnionAll1"."C25" AS "C72",
"UnionAll1"."C26" AS "C73",
"UnionAll1"."C27" AS "C74"
FROM (SELECT
CASE WHEN ("Extent2"."FIRMWARE_ID" IS NULL) THEN NULL ELSE 1 END AS "C1",
1 AS "C2",
"Extent1"."HEADER_ID" AS "HEADER_ID",
"Extent1"."STORAGE_ID" AS "STORAGE_ID",
"Extent1"."TESTSYSTEM" AS "TESTSYSTEM",
"Extent1"."TESTSYSTEMCALIBNO" AS "TESTSYSTEMCALIBNO",
"Extent1"."WINATS_VERSION" AS "WINATS_VERSION",
"Extent1"."PSL_NAME" AS "PSL_NAME",
"Extent1"."TESTDATE" AS "TESTDATE",
"Extent1"."TESTPROGBASE" AS "TESTPROGBASE",
"Extent1"."TESTPROGREV" AS "TESTPROGREV",
"Extent1"."TESTPROGDATE" AS "TESTPROGDATE",
"Extent1"."DEVICESERIALNOLIST" AS "DEVICESERIALNOLIST",
"Extent1"."FIXTURENOLIST" AS "FIXTURENOLIST",
"Extent1"."ARRAYLAYOUTX" AS "ARRAYLAYOUTX",
"Extent1"."ARRAYLAYOUTY" AS "ARRAYLAYOUTY",
"Extent1"."REMARK1" AS "REMARK1",
"Extent1"."REMARK2" AS "REMARK2",
"Extent1"."PRODSTATUS" AS "PRODSTATUS",
"Extent1"."REPAIRNO" AS "REPAIRNO",
"Extent1"."TESTSTARTMODE" AS "TESTSTARTMODE",
"Extent1"."TESTSTARTSUPERVISOR" AS "TESTSTARTSUPERVISOR",
"Extent1"."RCI_EDM_SETTING" AS "RCI_EDM_SETTING",
"Extent1"."RCI_EDM_SUPERVISOR" AS "RCI_EDM_SUPERVISOR",
"Extent1"."RCI_EDM_RELEASEREASON" AS "RCI_EDM_RELEASEREASON",
"Extent1"."RCI_PAR_SETTING" AS "RCI_PAR_SETTING",
"Extent1"."RCI_PAR_SUPERVISOR" AS "RCI_PAR_SUPERVISOR",
"Extent1"."RCI_PROG_SETTING" AS "RCI_PROG_SETTING",
"Extent1"."RCI_PROG_SUPERVISOR" AS "RCI_PROG_SUPERVISOR",
"Extent1"."RCI_PPS_SETTING" AS "RCI_PPS_SETTING",
"Extent1"."RCI_PPS_SUPERVISOR" AS "RCI_PPS_SUPERVISOR",
"Extent1"."OPERATOR_NO" AS "OPERATOR_NO",
"Extent1"."AMBTEMPERATURELOWERLIMIT" AS "AMBTEMPERATURELOWERLIMIT",
"Extent1"."AMBTEMPERATUREUPPERLIMIT" AS "AMBTEMPERATUREUPPERLIMIT",
"Extent1"."AMBHUMIDITYLOWERLIMIT" AS "AMBHUMIDITYLOWERLIMIT",
"Extent1"."AMBHUMIDITYUPPERLIMIT" AS "AMBHUMIDITYUPPERLIMIT",
"Extent1"."ORDERTYPE" AS "ORDERTYPE",
"Extent1"."CREATION_DATE" AS "CREATION_DATE",
"Extent1"."CHANGE_DATE" AS "CHANGE_DATE",
"Extent2"."FIRMWARE_ID" AS "FIRMWARE_ID",
"Extent2"."HEADER_ID" AS "HEADER_ID1",
"Extent2"."INDEXNO" AS "INDEXNO",
"Extent2"."FIRMWARE" AS "FIRMWARE",
"Extent2"."RELEASESTATE" AS "RELEASESTATE",
"Extent2"."MOVEXENTRY" AS "MOVEXENTRY",
"Extent2"."SUPERVISOR" AS "SUPERVISOR",
"Extent2"."COMMENTS" AS "COMMENTS",
"Extent2"."CREATION_DATE" AS "CREATION_DATE1",
"Extent2"."CHANGE_DATE" AS "CHANGE_DATE1",
NULL AS "C3",
NULL AS "C4",
NULL AS "C5",
NULL AS "C6",
NULL AS "C7",
NULL AS "C8",
NULL AS "C9",
NULL AS "C10",
NULL AS "C11",
NULL AS "C12",
NULL AS "C13",
NULL AS "C14",
NULL AS "C15",
NULL AS "C16",
NULL AS "C17",
NULL AS "C18",
NULL AS "C19",
NULL AS "C20",
NULL AS "C21",
NULL AS "C22",
NULL AS "C23",
NULL AS "C24",
NULL AS "C25",
NULL AS "C26",
NULL AS "C27"
FROM "PPLADMIN"."PPL_MEA_HEADER_T" "Extent1"
LEFT OUTER JOIN "PPLADMIN"."PPL_FIRMWARE_T" "Extent2" ON "Extent1"."HEADER_ID" = "Extent2"."HEADER_ID"
WHERE ("Extent1"."STORAGE_ID" = :p__linq__0)
UNION ALL
SELECT
2 AS "C1",
2 AS "C2",
"Extent3"."HEADER_ID" AS "HEADER_ID",
"Extent3"."STORAGE_ID" AS "STORAGE_ID",
"Extent3"."TESTSYSTEM" AS "TESTSYSTEM",
"Extent3"."TESTSYSTEMCALIBNO" AS "TESTSYSTEMCALIBNO",
"Extent3"."WINATS_VERSION" AS "WINATS_VERSION",
"Extent3"."PSL_NAME" AS "PSL_NAME",
"Extent3"."TESTDATE" AS "TESTDATE",
"Extent3"."TESTPROGBASE" AS "TESTPROGBASE",
"Extent3"."TESTPROGREV" AS "TESTPROGREV",
"Extent3"."TESTPROGDATE" AS "TESTPROGDATE",
"Extent3"."DEVICESERIALNOLIST" AS "DEVICESERIALNOLIST",
"Extent3"."FIXTURENOLIST" AS "FIXTURENOLIST",
"Extent3"."ARRAYLAYOUTX" AS "ARRAYLAYOUTX",
"Extent3"."ARRAYLAYOUTY" AS "ARRAYLAYOUTY",
"Extent3"."REMARK1" AS "REMARK1",
"Extent3"."REMARK2" AS "REMARK2",
"Extent3"."PRODSTATUS" AS "PRODSTATUS",
"Extent3"."REPAIRNO" AS "REPAIRNO",
"Extent3"."TESTSTARTMODE" AS "TESTSTARTMODE",
"Extent3"."TESTSTARTSUPERVISOR" AS "TESTSTARTSUPERVISOR",
"Extent3"."RCI_EDM_SETTING" AS "RCI_EDM_SETTING",
"Extent3"."RCI_EDM_SUPERVISOR" AS "RCI_EDM_SUPERVISOR",
"Extent3"."RCI_EDM_RELEASEREASON" AS "RCI_EDM_RELEASEREASON",
"Extent3"."RCI_PAR_SETTING" AS "RCI_PAR_SETTING",
"Extent3"."RCI_PAR_SUPERVISOR" AS "RCI_PAR_SUPERVISOR",
"Extent3"."RCI_PROG_SETTING" AS "RCI_PROG_SETTING",
"Extent3"."RCI_PROG_SUPERVISOR" AS "RCI_PROG_SUPERVISOR",
"Extent3"."RCI_PPS_SETTING" AS "RCI_PPS_SETTING",
"Extent3"."RCI_PPS_SUPERVISOR" AS "RCI_PPS_SUPERVISOR",
"Extent3"."OPERATOR_NO" AS "OPERATOR_NO",
"Extent3"."AMBTEMPERATURELOWERLIMIT" AS "AMBTEMPERATURELOWERLIMIT",
"Extent3"."AMBTEMPERATUREUPPERLIMIT" AS "AMBTEMPERATUREUPPERLIMIT",
"Extent3"."AMBHUMIDITYLOWERLIMIT" AS "AMBHUMIDITYLOWERLIMIT",
"Extent3"."AMBHUMIDITYUPPERLIMIT" AS "AMBHUMIDITYUPPERLIMIT",
"Extent3"."ORDERTYPE" AS "ORDERTYPE",
"Extent3"."CREATION_DATE" AS "CREATION_DATE",
"Extent3"."CHANGE_DATE" AS "CHANGE_DATE",
NULL AS "C3",
NULL AS "C4",
NULL AS "C5",
NULL AS "C6",
NULL AS "C7",
NULL AS "C8",
NULL AS "C9",
NULL AS "C10",
NULL AS "C11",
NULL AS "C12",
"Extent4"."DATASET_ID" AS "DATASET_ID",
"Extent4"."HEADER_ID" AS "HEADER_ID1",
"Extent4"."DUT_NO" AS "DUT_NO",
"Extent4"."CIRCUITNO" AS "CIRCUITNO",
"Extent4"."TESTRESULT" AS "TESTRESULT",
"Extent4"."TESTOPERATIONMODE" AS "TESTOPERATIONMODE",
"Extent4"."SERIALNOTYPE" AS "SERIALNOTYPE",
"Extent4"."SERIALNO" AS "SERIALNO",
"Extent4"."ARRAYSERIALNOTYPE" AS "ARRAYSERIALNOTYPE",
"Extent4"."ARRAYSERIALNO" AS "ARRAYSERIALNO",
"Extent4"."AMBTEMPERATURE" AS "AMBTEMPERATURE",
"Extent4"."AMBHUMIDITY" AS "AMBHUMIDITY",
"Extent4"."RUNINTEMP" AS "RUNINTEMP",
"Extent4"."BREAK" AS "BREAK",
"Extent4"."CREATION_DATE" AS "CREATION_DATE1",
"Extent4"."CHANGE_DATE" AS "CHANGE_DATE1",
NULL AS "C13",
NULL AS "C14",
NULL AS "C15",
NULL AS "C16",
NULL AS "C17",
NULL AS "C18",
NULL AS "C19",
NULL AS "C20",
NULL AS "C21"
FROM "PPLADMIN"."PPL_MEA_HEADER_T" "Extent3"
INNER JOIN "PPLADMIN"."PPL_MEA_DATASET_T" "Extent4" ON "Extent3"."HEADER_ID" = "Extent4"."HEADER_ID"
WHERE ("Extent3"."STORAGE_ID" = :p__linq__0)) "UnionAll1"
UNION ALL
SELECT
3 AS "C1",
3 AS "C2",
"Extent5"."HEADER_ID" AS "HEADER_ID",
"Extent5"."STORAGE_ID" AS "STORAGE_ID",
"Extent5"."TESTSYSTEM" AS "TESTSYSTEM",
"Extent5"."TESTSYSTEMCALIBNO" AS "TESTSYSTEMCALIBNO",
"Extent5"."WINATS_VERSION" AS "WINATS_VERSION",
"Extent5"."PSL_NAME" AS "PSL_NAME",
"Extent5"."TESTDATE" AS "TESTDATE",
"Extent5"."TESTPROGBASE" AS "TESTPROGBASE",
"Extent5"."TESTPROGREV" AS "TESTPROGREV",
"Extent5"."TESTPROGDATE" AS "TESTPROGDATE",
"Extent5"."DEVICESERIALNOLIST" AS "DEVICESERIALNOLIST",
"Extent5"."FIXTURENOLIST" AS "FIXTURENOLIST",
"Extent5"."ARRAYLAYOUTX" AS "ARRAYLAYOUTX",
"Extent5"."ARRAYLAYOUTY" AS "ARRAYLAYOUTY",
"Extent5"."REMARK1" AS "REMARK1",
"Extent5"."REMARK2" AS "REMARK2",
"Extent5"."PRODSTATUS" AS "PRODSTATUS",
"Extent5"."REPAIRNO" AS "REPAIRNO",
"Extent5"."TESTSTARTMODE" AS "TESTSTARTMODE",
"Extent5"."TESTSTARTSUPERVISOR" AS "TESTSTARTSUPERVISOR",
"Extent5"."RCI_EDM_SETTING" AS "RCI_EDM_SETTING",
"Extent5"."RCI_EDM_SUPERVISOR" AS "RCI_EDM_SUPERVISOR",
"Extent5"."RCI_EDM_RELEASEREASON" AS "RCI_EDM_RELEASEREASON",
"Extent5"."RCI_PAR_SETTING" AS "RCI_PAR_SETTING",
"Extent5"."RCI_PAR_SUPERVISOR" AS "RCI_PAR_SUPERVISOR",
"Extent5"."RCI_PROG_SETTING" AS "RCI_PROG_SETTING",
"Extent5"."RCI_PROG_SUPERVISOR" AS "RCI_PROG_SUPERVISOR",
"Extent5"."RCI_PPS_SETTING" AS "RCI_PPS_SETTING",
"Extent5"."RCI_PPS_SUPERVISOR" AS "RCI_PPS_SUPERVISOR",
"Extent5"."OPERATOR_NO" AS "OPERATOR_NO",
"Extent5"."AMBTEMPERATURELOWERLIMIT" AS "AMBTEMPERATURELOWERLIMIT",
"Extent5"."AMBTEMPERATUREUPPERLIMIT" AS "AMBTEMPERATUREUPPERLIMIT",
"Extent5"."AMBHUMIDITYLOWERLIMIT" AS "AMBHUMIDITYLOWERLIMIT",
"Extent5"."AMBHUMIDITYUPPERLIMIT" AS "AMBHUMIDITYUPPERLIMIT",
"Extent5"."ORDERTYPE" AS "ORDERTYPE",
"Extent5"."CREATION_DATE" AS "CREATION_DATE",
"Extent5"."CHANGE_DATE" AS "CHANGE_DATE",
NULL AS "C3",
NULL AS "C4",
NULL AS "C5",
NULL AS "C6",
NULL AS "C7",
NULL AS "C8",
NULL AS "C9",
NULL AS "C10",
NULL AS "C11",
NULL AS "C12",
NULL AS "C13",
NULL AS "C14",
NULL AS "C15",
NULL AS "C16",
NULL AS "C17",
NULL AS "C18",
NULL AS "C19",
NULL AS "C20",
NULL AS "C21",
NULL AS "C22",
NULL AS "C23",
NULL AS "C24",
NULL AS "C25",
NULL AS "C26",
NULL AS "C27",
NULL AS "C28",
"Extent6"."TESTSTEP_ID" AS "TESTSTEP_ID",
"Extent6"."HEADER_ID" AS "HEADER_ID1",
"Extent6"."INDEXNO" AS "INDEXNO",
"Extent6"."NAME" AS "NAME",
"Extent6"."LOWERLIMIT" AS "LOWERLIMIT",
"Extent6"."UPPERLIMIT" AS "UPPERLIMIT",
"Extent6"."UNIT" AS "UNIT",
"Extent6"."CREATION_DATE" AS "CREATION_DATE1",
"Extent6"."CHANGE_DATE" AS "CHANGE_DATE1"
FROM "PPLADMIN"."PPL_MEA_HEADER_T" "Extent5"
INNER JOIN "PPLADMIN"."PPL_TESTSTEP_T" "Extent6" ON "Extent5"."HEADER_ID" = "Extent6"."HEADER_ID"
WHERE ("Extent5"."STORAGE_ID" = :p__linq__0)) "UnionAll2"
ORDER BY "UnionAll2"."C3" ASC, "UnionAll2"."C1" ASC
Ich habe schon gegoogelt aber nur Beiträge gefunden mit der Problem ohne Lösung oder Workaround.
Entity Framework multiple Include causes ORA-01790 error
und
Can't use EntityFramework .Include() when targetting an Oracle database (ORA-01790)
kennt jemand das problem oder hat eine Idee wie ich diese query auch in oracle 10g ohne fehler ausführen kann?
Die früheren Versionen vom EF haben Include nur auf dem MSSQL unterstützt; evtl. gilt das in Hinsicht von Oracle hier auch noch.
Ansonsten mal 5.0 ausprobieren oder einen anderen ORM / Provider verwenden.
- performance is a feature -
Microsoft MVP - @Website - @AzureStuttgart - github.com/BenjaminAbt - Sustainable Code
Hallo,
1)EF 4.3 unterstützt bei mir Includes in Oracle 11.2. Die Fehlermeldung kommt nur bei Oracle Version 10.2.
Ich habe schon so viel Zeit investiert mit diesen ORM, dass ein Wechsel nicht lohnt. deswegen suche nach einem Workaround für mein Problem wenn ein schon gibt.
Ich weiss nicht ob oracle + EF vielleicht die beste Wahl und kompatibel ist weil Mikrosoft EF mehr ihre db unterstützt und wenig für andere tut. umgekehrt tut oracle auch wenig um mikrosoft Produkte zu unterstützen und jeder schibt den anderen den Schuld wenn was nicht geht.
Dafür kann MS nix. MS stellt Schnittstellen zur Verfügung; für den jeweiligen ADO Provider ist der Hersteller, hier Oracle verantwortlich. Von daher ist das Tun definitiv Oracle's Sache.
Und wenn der Oracle Provider das nicht unterstützt, dann liegt das wohl an Oracle's Seite.
Also dort schlau machen, obs nen anderen Provider gibt. Das war bei meinem vorherigen Beitrag etwas unglücklich ausgedrückt von mir.
Die früheren Provider haben dies eben nicht unterstützt. Evtl. ist ja für die Unterstützung seitens Oracle eben auch was an der Basis notwendig gewesen, weshalb es mit 10.2 generell nicht geht.
- performance is a feature -
Microsoft MVP - @Website - @AzureStuttgart - github.com/BenjaminAbt - Sustainable Code
ich habe neue Erkenntnisse
wenn ich eine Include auskommentiere egal welche kommt die Fehlermeldung nicht mehr!
var headers_query = context.PPL_MEA_HEADER_T.Where(h => h.STORAGE_ID == storage.STORAGE_ID)
.Include(h => h.PPL_FIRMWARE_T)
.Include(h => h.PPL_MEA_DATASET_T);
//.Include(h => h.PPL_TESTSTEP_T).AsNoTracking();
das ganze ist sehr sensibel. Ich habe immer neue Effekte wenn ich andere Oracle Version(10,11) oder anderen BS(xp,7) habe.
Mit Devart gibt es einen drittAnbieter der Tools und treiber rund um das Thema Oracle/Ef bereitstellt. Allerdings weis ich nicht ob include hier mit ef4.3 zusammenarbeitet, aber ich habe auch noch nichts gegenteiliges gehört.
Ist allerdings kostenpflichtig.