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.
我想知道是否有人已经在生产环境中使用Entity Framework和Oracle数据库?在ODP.Net中似乎不支持EF,并且只有第三方数据提供者(OraDirect)似乎可以与Oracle连接。有人提到Codeplex上提供了asample数据提供程序,但它提供的信息是它永远不应该在生产环境中使用。
Are you using EF with an Oracle database already?
您是否已将EF与Oracle数据库一起使用?
2 个解决方案
#1
2
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.
就个人而言,我不会尝试这个。示例数据提供程序上的消息足够警告。在这种配置中,你需要经过验证才能使用EF,这是不值得的,IMO。
#2
0
I've installed this from Oracle
我已经从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.
我遇到的唯一问题是当我有一个带有SEQ + Trigger的表有“auto ident”字段时,当我添加一个contextobject时,框架不会返回“SaveChanges()”上的数字。但记录本身插入正常。
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.
我正在做的应用程序只是在公司内部使用。但是,由于该公司的主要系统是Oracle上的Microsoft XAL,因此可以通过这种方式进行更多的应用程序。所以当然希望很快得到稳定的发展。
\T
#1
2
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.
就个人而言,我不会尝试这个。示例数据提供程序上的消息足够警告。在这种配置中,你需要经过验证才能使用EF,这是不值得的,IMO。
#2
0
I've installed this from Oracle
我已经从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.
我遇到的唯一问题是当我有一个带有SEQ + Trigger的表有“auto ident”字段时,当我添加一个contextobject时,框架不会返回“SaveChanges()”上的数字。但记录本身插入正常。
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.
我正在做的应用程序只是在公司内部使用。但是,由于该公司的主要系统是Oracle上的Microsoft XAL,因此可以通过这种方式进行更多的应用程序。所以当然希望很快得到稳定的发展。
\T