5

Somebody advised me to use Entity Framework here when I asked this question: what is better to build Data layer, Strongly Typed DataSets or Classes

So I read a lot of articles about Entity Framework, I understood that Entity Framework designed to be data-source independent and it will support most of the popular DBMSs.

I Have vs2008 with SP1, and I tried to add ADO.NET Entity Data Model, but I couldn't generate the model from Oracle connection, it seems that it's just supporting SQL Server!!

So does it support Oracle or not yet?!

Improve this question

2 Answers 2

Reset to default
4

I also followed multiple tutorials for a model-first entity framework design with Oracle but they all hit the same dead-end.

I was able to connect to my Oracle database through Server Explorer but not when adding an ADO.NET Entity Data Model. All I saw was SQL Server Drivers to choose from.

I eventually ready this article which stated the following:

The 32-bit Oracle Developer Tools for Visual Studio download from http://otn.oracle.com/dotnet is required for Entity Framework design-time features and for other Visual Studio designers such as the TableAdapter Wizard. This NuGet download does not enable design-time tools, only run-time support.

Following the link provided from the article, I downloaded the 32-bit ODAC with Oracle Developer Tools for Visual Studio and this allowed me connect to my Oracle DB.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

3

http://code.msdn.microsoft.com/EFOracleProvider
Can you use Microsoft Entity Framework with Oracle?

Improve this answer

1 Comment

it seems that still no solution coming from the Microsoft camp and all the other solutions are commercial or tests that you can't use in production environments. Anyway thanks for your help...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.