Thursday, June 6, 2013

Using ORACLE database with Visual Studio for ASP.NET MVC4 website using Entity Framework

These days Microsoft's ASP.NET MVC4 is being used for latest cutting edge website development. Because of the ease that Entity Framework provides it is very well adopted by the developer community. Though it is fully compatible with Microsoft SQL Server database and other databases are still trying to provide support of EF. In case you want to use Oracle with Entity Framework then you need to install Oracle Data Access Components (ODAC) and Oracle Developer Tools.

Please note, as of now, Oracle support for Entity Framework only supports Model First approach. Though there are ways to approach Code-First too but it is not very well supported yet.

To install ODAC and ODET, it might get somewhat confusing and reaching to the appropriate knowledge document might get difficult. Here is the link by Oracle discussing how to install .NET components:
http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/installation.htm

Share your experience with installation.

No comments:

Post a Comment