Hello. I am running an oracle 12c pdb. I create a new MVC project using VS 2013 and install EF6. When I use DB first and back into my models using my Oracle pdb, VS tells me that I can't use EF6, only EF5. Very confusing. I've tried to install all the
different Oracle NuGet packages and that only makes things worse. If you install any of the Oracle NuGet packages, it blocks things altogether. I'm stumped. I want to use EF6 but am forced into using EF5 at this point.
Did you install the Oracle Data Access Client 12c R4 32-bit with Visual Studio 2013 Oracle Developer Tools in addition to your Oracle 12c Personal Database?
Required for Entity Framework.
Install in the same ORACLE_BASE directory but in a different ORACLE_HOME directory.
Oracle Developer Tools for Visual Studio 2013 (12.1.0.2.4)
Download the File[Released October 29, 2015]
SetupODTforVS2013.exe 62 MB (61,624,144 bytes)
Important: Before you install this package please make sure there is no ODAC/Oracle Universal Installer (OUI) version of Oracle Developer Tools for Visual Studio installed on the machine. If there is then please use OUI to uninstall Oracle Developer
Tools for Visual Studio before proceeding with this install.
This download includes:
Oracle Developer Tools for Visual Studio 12.1.0.2.4
Oracle Data Provider for .NET 4, Managed Driver 12.1.0.2.0
Oracle Providers for ASP.NET 4 12.1.0.2.0
This download does not include support for User Defined Types nor Oracle Database Extensions for .NET.
If you require Oracle Data Provider for .NET, Unmanaged Driver then please
download the ODAC/OUI version of Oracle Developer Tools for Visual Studio.
Member
26 Points
69 Posts
Oracle 12c, Visual Studio 2013, EF6
Mar 01, 2016 10:22 PM|id3ma|LINK
Hello. I am running an oracle 12c pdb. I create a new MVC project using VS 2013 and install EF6. When I use DB first and back into my models using my Oracle pdb, VS tells me that I can't use EF6, only EF5. Very confusing. I've tried to install all the different Oracle NuGet packages and that only makes things worse. If you install any of the Oracle NuGet packages, it blocks things altogether. I'm stumped. I want to use EF6 but am forced into using EF5 at this point.
Star
12330 Points
2021 Posts
Re: Oracle 12c, Visual Studio 2013, EF6
Mar 02, 2016 03:21 AM|Candice Zhou|LINK
Hi id3ma,
To add Oracle provider you need to open web.config and add following:
You can check if it's needed in your case.
For more information about using entity framework 6, database-first with Oracle, you could refer to the below link:
https://csharp.today/entity-framework-6-database-first-with-oracle/
Best Regards,
Candice Zhou
Member
26 Points
69 Posts
Re: Oracle 12c, Visual Studio 2013, EF6
Mar 02, 2016 10:23 PM|id3ma|LINK
Thank you! Hopefully this makes the headaches go away.
Member
26 Points
69 Posts
Re: Oracle 12c, Visual Studio 2013, EF6
Mar 03, 2016 11:08 PM|id3ma|LINK
Well unfortunately it's still not working. Followed every step in the C# today post. Frustrating.
Contributor
3532 Points
1348 Posts
Re: Oracle 12c, Visual Studio 2013, EF6
Mar 06, 2016 05:32 PM|Lannie|LINK
Did you install the Oracle Data Access Client 12c R4 32-bit with Visual Studio 2013 Oracle Developer Tools in addition to your Oracle 12c Personal Database?
Required for Entity Framework.
Install in the same ORACLE_BASE directory but in a different ORACLE_HOME directory.
http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html
Oracle Developer Tools for Visual Studio 2013 (12.1.0.2.4)
Important: Before you install this package please make sure there is no ODAC/Oracle Universal Installer (OUI) version of Oracle Developer Tools for Visual Studio installed on the machine. If there is then please use OUI to uninstall Oracle Developer Tools for Visual Studio before proceeding with this install.
This download includes:
This download does not include support for User Defined Types nor Oracle Database Extensions for .NET.
If you require Oracle Data Provider for .NET, Unmanaged Driver then please download the ODAC/OUI version of Oracle Developer Tools for Visual Studio.