CODEWITHSUNDEEP
.netoracle-databaseentity-framework
Xerx
Xerx

Reputation: 3775

Is anyone using Entity Framework with an Oracle database?

I am wondering if anyone is already using Entity Framework with an Oracle database in a production environment? There seems to be no support for EF in ODP.Net and only 3rd party data providers (OraDirect) seem to be available to connect with Oracle. Someone mentioned asample data provider available on Codeplex but it is presented with the message that it should never be used in a production environment.

Are you using EF with an Oracle database already?

Upvotes: 2

Views: 1686

Answers (2)

Thomas Hansen
Thomas Hansen

Reputation: 193

I've installed this from Oracle

http://www.oracle.com/technetwork/topics/dotnet/downloads/oracleefbeta-302521.html

The only problem i have accoured is when i have a table with a SEQ+Trigger to have "auto ident" field, the framework doesn't return the number on "SaveChanges()" when i adds a contextobject. But the record itself gets inserted fine.

Otherwise it seems ok.

The app i'm doing is only to be used internaly in the company. But as the companys main system is Microsoft XAL on Oracle, there proberly will be more apps done this way. So ofcourse hope for a stable realease soon.

\T

Upvotes: 0

KevDog
KevDog

Reputation: 5803

Personally, I wouldn't attempt this yet. The message on the sample data provider is warning enough. The level of validation you would need to go through to be comfortable using EF in this configuration wouldn't be worth the effort, IMO.

Upvotes: 2

Related Questions