Working with MVC + Entity Framework + Oracle Database

Hey, Have started working with MVC, entity framework and Oracle database???

That's worth to learn. You might fall in a situation that you don't find Oracle Connection when choosing new datasource from entity framework new connection option.

If oracle connection option is missing (I hope you've installed Oracle DB 10g or 11g) then what to do??

you need to setup Oracle Data Access Components.

Software Link:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
Documentation:
http://www.oracle.com/technetwork/topics/dotnet/install112012-164342.html

Note:

VS 2013 you need ODAC 12c (12.1.0.2.1) or later. you cannot work with 11.1 version series if you have 2013.

Now what?? While installation you need to show where your Oracle base path is. base path is something directory like this... X:\oracle11g\product . X is your drive letter :P 
[I know you are smart enough to understand this]

What you had to do if don't setup like this... ??? Nothing complex...

You had to copy two (2) file inside e.g. E:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN.

to ODAC location e.g. x:\whatever\product\12.1.0\client_1.

What are those two file?

tnsnames.ora 
and
sqlnet.ora

What these two files do? They just show the path where oracle_home is...

now I hope all is set...

now open you MVC project. add new item > entity framework> wizard will show Oracle Connection as intended.

You may try EZConnection.

see the screenshot. one screenshot can tell more than me withing less time... :) 

If you feel problem you can contact me...
This video tutorial may help you.