locked
Oracle 12c, Visual Studio 2013, EF6 RRS feed

  • Question

  • User562699594 posted

    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.

    Tuesday, March 1, 2016 10:22 PM

All replies

  • User614698185 posted

    Hi id3ma,

    To add Oracle provider you need to open web.config and add following:

    <configuration>
     <entityFramework>
      <providers>
       <provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, 
    Oracle.ManagedDataAccess.EntityFramework, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

    You can check if it's needed in your case.

    <configuration>
     <configSections>
      <section name="Oracle.ManagedDataAccess.Client" type="OracleInternal.Common.ODPMSectionHandler, 
    Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

    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

    Wednesday, March 2, 2016 3:21 AM
  • User562699594 posted

    Thank you!  Hopefully this makes the headaches go away.

    Wednesday, March 2, 2016 10:23 PM
  • User562699594 posted

    Well unfortunately it's still not working.  Followed every step in the C# today post.  Frustrating.

    Thursday, March 3, 2016 11:08 PM
  • User269602965 posted

    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)

     Download the File             [Released October 29, 2015]
      Download 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.

     

    Sunday, March 6, 2016 5:32 PM