c# - Entity Framework Code First and Oracle ODAC 12c Release 3 Error -

c# - Entity Framework Code First and Oracle ODAC 12c Release 3 Error -

a bit stumped one...

i'm receiving next error when setting code first on entity framework , oracle...

no entity framework provider found ado.net provider invariant name 'oracle.manageddataaccess.client'. create sure provider registered in 'entityframework' section of application config file.

with next setup...

entity framework 6.1.1

odac 12c release 3

any ideas on how prepare problem?

i've included app.config file below...

<?xml version="1.0" encoding="utf-8"?> <configuration> <configsections> <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entityframework, version=6.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089" requirepermission="false" /> <!-- more info on entity framework configuration, visit http://go.microsoft.com/fwlink/?linkid=237468 --></configsections> <startup> <supportedruntime version="v4.0" sku=".netframework,version=v4.5" /> </startup> <connectionstrings> <add name="context" connectionstring="data source=****;password=****;persist security info=true;pooling=false;user id=system" providername="oracle.manageddataaccess.client" /> </connectionstrings> <entityframework> <defaultconnectionfactory type="system.data.entity.infrastructure.localdbconnectionfactory, entityframework"> <parameters> <parameter value="v11.0" /> </parameters> </defaultconnectionfactory> <providers> <provider invariantname="system.data.sqlclient" type="system.data.entity.sqlserver.sqlproviderservices, entityframework.sqlserver" /> </providers> </entityframework> </configuration>

since have used providername oracle.manageddataaccess.client in connectionstring. need add together line in next section define it:

<providers> <provider invariantname="oracle.manageddataaccess.client" type="oracle.manageddataaccess.entityframework.eforacleproviderservices,oraclemanageddataaccess.entityframework" /> </providers>

c# .net oracle entity-framework-6