Willkommen auf myCSharp.de! Anmelden | kostenlos registrieren
 | Suche | FAQ

Hauptmenü
myCSharp.de
» Startseite
» Forum
» Suche
» Regeln
» Wie poste ich richtig?

Mitglieder
» Liste / Suche
» Wer ist online?

Ressourcen
» FAQ
» Artikel
» C#-Snippets
» Jobbörse
» Microsoft Docs

Team
» Kontakt
» Cookies
» Spenden
» Datenschutz
» Impressum

  • »
  • Community
  • |
  • Diskussionsforum
Entityframework + Oracle 10: ORA-01790 Error
sindibad
myCSharp.de - Member



Dabei seit:
Beiträge: 110

Themenstarter:

Entityframework + Oracle 10: ORA-01790 Error

beantworten | zitieren | melden

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?
private Nachricht | Beiträge des Benutzers
Abt
myCSharp.de - Team

Avatar #avatar-4119.png


Dabei seit:
Beiträge: 16145

beantworten | zitieren | melden

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 - @blog - @AzureStuttgart - github.com/BenjaminAbt
private Nachricht | Beiträge des Benutzers
sindibad
myCSharp.de - Member



Dabei seit:
Beiträge: 110

Themenstarter:

beantworten | zitieren | melden

Hallo,
1)EF 4.3 unterstützt bei mir Includes in Oracle 11.2. Die Fehlermeldung kommt nur bei Oracle Version 10.2.

2) Ich bin von EF 5 auf EF 4.3 zurück weil meine Bibliothek mit xp kompatibel sein muss.
siehe dazu meine Frage in Forum
entity framework und cryptographic algorithm not supported expetion in win xp

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.
private Nachricht | Beiträge des Benutzers
Abt
myCSharp.de - Team

Avatar #avatar-4119.png


Dabei seit:
Beiträge: 16145

beantworten | zitieren | melden

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 - @blog - @AzureStuttgart - github.com/BenjaminAbt
private Nachricht | Beiträge des Benutzers
sindibad
myCSharp.de - Member



Dabei seit:
Beiträge: 110

Themenstarter:

beantworten | zitieren | melden

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.
private Nachricht | Beiträge des Benutzers
unconnected
myCSharp.de - Member

Avatar #avatar-3200.jpg


Dabei seit:
Beiträge: 862
Herkunft: Oerlinghausen/NRW

beantworten | zitieren | melden

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.
private Nachricht | Beiträge des Benutzers