I am using Entity framework 6.1 version and oracle 11. I am new to entity framework. Can anyone please suggest what are the prerequisites for connecting with oracle. any changes are required in the web.config. In web.config,default it is connecting with sql,how can i change it to use Oracle instead of sql.
-
community.oracle.com/thread/2472399? download.oracle.com/oll/obe/EntityFrameworkOBE/…?Dylan Corriveau– Dylan Corriveau2015-04-30 13:57:16 +00:00Commented Apr 30, 2015 at 13:57
-
If you used NuGet, it should modify your web/app config for you. Also, since the EF version is another common gotcha, if you uninstall EF, the NuGet package for the Oracle.ManagedDataAccess.EntityFramework will download the version it's compatible with.Mike_Matthews_II– Mike_Matthews_II2015-05-04 16:37:19 +00:00Commented May 4, 2015 at 16:37
Add a comment
|
1 Answer
I have a sample project with EF 6 and oracle 11g which only uses nuget packages:
https://github.com/ovidiubuligan/EntityFramework_Oracle_sample
The most important parts are App.config and packages.config.
If you look in App.config you will see that it will use the connection string :
connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=... instead of a tns file http://www.orafaq.com/wiki/Tnsnames.ora . I find it more confortable.
1 Comment
AMDI
Thanks for the link.it is working with some changes.