所以，我正在公司启动一个新项目，它有点大。我们将使用 .NET 3.5，我想知道是否有任何已知的错误或性能问题可能会给我的项目带来奇怪的行为？我正在阅读一些有关 EFv4 的内容，他们都说 EFv3.5 有太多问题。
毕竟，什么是最好和最快的方法，ADO.NET 实体或将数据从我的数据库直接提取到 DataReader？ EF Oracle 提供商稳定吗？
该项目将是.NET 3.5 和 Oracle。
So, I'm starting a new Project in my company, and it's kinda big. We are going to use .NET 3.5, and I wish to known if there are any know bugs or perfomance issues that could give weird behaviour for my project? I'm reading some things about EFv4 and all they say is that EFv3.5 have too many problems.
After all, what's the best and fastest way, ADO.NET Entities or extract the data from my DB directly to a DataReader? The EF Oracle provider is stable?
The project will be .NET 3.5 and Oracle.
发布评论
评论（2）
您将遇到的第一个问题是 Oracle/EF 障碍。由于 Oracle 或 MS 都不提供此类服务，因此您必须使用第三方。 有一些。
还有其他 ORM。也许这是一个很好的比较？
http://ormeter.net/
我还认为你的问题可能更好地通过询问“我应该使用什么 ORM鉴于X技术”。您应该根据您的要求和约束来选择 ORM。
The first problem you'll experience out of the gate will be the Oracle/EF hurdle. Since neither Oracle or MS provide one you'll have to go third party. There are a few out there.
There are other ORM's out there.. maybe this is a good comparison?
http://ormeter.net/
I also think your question might be better served by asking "What ORM should I use given X technology". You should be picking an ORM based on your requirements and constraints.
好吧，如果您正在寻找 EF，您也可以考虑 Nhibernate，根据我的经验，它要好得多。在工作中，我们尝试了两者并选择了第二个，因为您还可以在其中编写一些原始 Sql (hql) 查询。
如果您仍然决定使用 Ado I 并且项目规模很大，您将需要一定的纪律，以免弄乱 sql 查询字符串。
附：
忘记提及 NHibernate 还支持 linq，与 EF 相比，它还可以生成更好、更干净的 SQL 查询。
Well if you were looking to EF you might also consider Nhibernate which in my expirience is much better. At work we tried both and chose the second because you can also write some raw Sql (hql) query in it.
If you still decide to use Ado I and the size of the project is big you'll need an amount of discipline not to mess with sql query strings around.
PS:
Forgot to mention that NHibernate supports also linq which also generates better and cleaner sql queries comparing to EF.