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:

Share your experience with installation.


  1. Given so much information in it. its very useful .perfect explanation about Dot net framework.Thanks for your valuable information. dot net training in chennai velachery | dot net training institute in velachery

  2. It is really a great work and the way in which u r sharing the knowledge is excellent.
    Thanks for helping me to understand basic concepts. As a beginner in Dot Net programming your post help me a lot.Thanks for your informative article.. dot net training and placement in chennai | best dot net training in chennai