ADO. NET Entity Framework providers for Oracle

Microsoft's vision. net is a wide one. in addition to their desire for it to support all programming languages, either directly or through interoperability layers, they also want to bring together all communication frameworks and data storage engines. while WCF is making headway for standardizing communication APIs, their universal data access model Entity Framework is lagging behind.

A major problem up until now is that the ADO. NET Entity Framework did not come with out of the box support for the major non-Microsoft databases such as oracle. this has opened a door for third-party vendors to fill in the gaps.

Once such vendor is data direct. for processing users their most important claim to fame is being 100% managed code. usually that isn' t really a big deal, but in this case it means that you can completely avoid the Oracle client.

Another vendor is devart. devart's offering has been on the scene a bit longer than data direct and offers a comparable feature list. and not surprisingly, not needing the Oracle client is number 1 on their feature list as well.

Oracle itself is strangely quiet on the matter. While Oracle does offer ODP. net, it is limited to the standard ADO. net design patterns.

 

Chinese version:

Microsoft has extensive definitions of. net. Except for allProgramming LanguageWhether directly or through interoperability, Microsoft also hopes to integrate all the communication frameworks and data storage engines. When WCF is already ahead of the standard communication API, Microsoft's General Data Access Model Entity Framework falls behind.

So far, the main problem with ADO. NET Entity Framework is that it does not support non-Microsoft mainstream databases, such as oracle. This provides opportunities for third-party vendors.

One of them is data direct. For most users, the most important feature they provide is 100% hosting.Code. Generally, this is not a big deal, but it means that you do not need the Oracle client at all.

Another vendor is devart. They started earlier than data direct and have similar features. Unexpectedly, the Oracle client is not required and is also their most important feature.

at the same time, Oracle itself seems abnormal. Although oracle also provides ODP. net, it only supports standard ADO. net.