Ef Model First, cannot generate sql in entity framework for oracle database

0 votes
asked Feb 3, 2016 by V2924it (1,600 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 Feb 9, 2016 by Lbhbut (1,360 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 Feb 11, 2016 by zlthis (1,550 points)
Along with all above answer i would like to add this point too. More docs here https://csharp.today/entity-framework-6-database-first-with-oracle/
commented Feb 12, 2016 by Is_5496 (830 points)
MS is best suited to solve the issue because APPLY doesn't just affect Oracle
commented Feb 13, 2016 by Yrn_Abts (540 points)
The way it is now, the Entity Framework is almost unusable with Oracle
0 votes
answered Feb 15, 2016 by tonetti (2,270 points)
Example code at ADO.NET - LINQ Tutorial and Oracle Entity SQL Queries
Here is a good video explaining
commented Feb 16, 2016 by theodor (810 points)
The Entity Framework itself does not generate the SQL statements
commented Feb 17, 2016 by Calder (410 points)
Here's an excerpt from one of the EF READMEs on the issue
0 votes
answered Feb 24, 2016 by manrriquezdo (1,370 points)
Re: Entity Framework generates invalid oracle sql
commented Feb 25, 2016 by itgreen (260 points)
Kinda late but here is what I did after encountering this problem

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!