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?!

ΩmegaMan
  • 29,542
  • 12
  • 100
  • 122
Wael Dalloul
  • 22,172
  • 11
  • 48
  • 57

2 Answers2

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.

362mike362
  • 61
  • 5
3

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

Community
  • 1
  • 1
HuBeZa
  • 4,715
  • 3
  • 36
  • 58
  • 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... – Wael Dalloul Aug 24 '09 at 07:52