BT

Oracle Provider Gets EF Support

by Roopesh Shenoy on Jan 02, 2012 |

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. 

Hello stranger!

You need to Register an InfoQ account or 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

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT