BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Oracle Provider Gets EF Support

| by Roopesh Shenoy Follow 0 Followers on Jan 02, 2012. Estimated reading time: 1 minute |

Oracle has recently released Oracle Data Access Components (ODAC) 11.2 Rel 4 with support for Entity Framework 4.1 and 4.2. This will allow .NET developers working with Oracle database to work with a popular ORM and use LINQ to Entities for data access operations instead of hand-coding the SQL statements. 

Although the new provider supports EF, it does not support some of the latest features like Code First and DbContext which were introduced in EF 4.1. On the other hand, apart from EF support, there are several other features introduced in the latest release; for example you can now write WCF Data Services for data in an Oracle Database. You can learn more about all the features supported in ODAC in the official documentation

The provider has been in beta for a while. There is an article on how to work with Oracle and EF using the Visual Studio Toolset as well as a simple tutorial to get developers started. 

Entity Framework is designed with a provider model so that it works with third party data providers. There is also a sample provider that shows how to do this for non-SQL Server databases. Oracle has now implemented this for Oracle database. 

Oracle is not the only non-SQL Server database to have a provider with EF support – the ADO.NET Providers page lists all the Third Party Providers for various databases that support Entity Framework. 

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT