Cannot generate sql in entity framework for oracle database


0 votes
asked Mar 16, 2016 by pna_That (460 points)
I am trying to generate oracle sql for my entity framework model. I can generate SQLServer sql fine, error only occurs with oracle generation.

4 Answers

0 votes
answered Mar 18, 2016 by there_Mowan (660 points)

Oracle has limited control over the SQL generated. Re: Entity Framework generates invalid oracle sql. NET make the Entity Framework (same version) generate different statements.
One can always use entity SQL or straight SQL.
0 votes
answered Mar 28, 2016 by kamelThought (1,800 points)
Check this Entity Framework - Code First to an Existing Database for more detailed information
For more details see this answer
0 votes
answered Apr 29, 2016 by Sbhit (220 points)
This would definitely work
Please read Entity Framework 6, database-first with Oracle | C# Today for information on the replacement for dynamic properties
commented May 1, 2016 by Dieter (100 points)
MS is best suited to solve the issue because APPLY doesn't just affect Oracle
commented May 1, 2016 by rss2168Sure (2,450 points)
The way it is now, the Entity Framework is almost unusable with Oracle
+1 vote
answered Jun 3, 2016 by Gur_Go (500 points)
Re: Entity Framework generates invalid oracle sql
commented Jun 4, 2016 by sbetypes (1,680 points) 1 flag
The Entity Framework itself does not generate the SQL statements
commented Jun 5, 2016 by burtle5896 (720 points)
Here's an excerpt from one of the EF READMEs on the issue
commented Jun 5, 2016 by Napper (110 points)
Idleft join ParameterSets ps on ug

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!







...