Oracle Exception problems in ASP.NET MVC -
i facing problems when use connection string below:
<configuration> <configsections> <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entityframework, version=6.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089" requirepermission="false" /> <section name="oracle.manageddataaccess.client" type="oracleinternal.common.odpmsectionhandler, oracle.manageddataaccess, version=4.121.1.0, culture=neutral, publickeytoken=89b483f429c47342" /> </configsections> <connectionstrings> <add name="oracleconnectionstring" providername="oracle.manageddataaccess.client" connectionstring="user id=testdb;password=testdb;data source=testdb" /> </connectionstrings> <entityframework> <defaultconnectionfactory type="oracle.manageddataaccess.entityframework.oracleconnectionfactory, oracle.manageddataaccess.entityframework"> </defaultconnectionfactory> <providers> <provider invariantname="oracle.manageddataaccess.client" type="oracle.manageddataaccess.entityframework.eforacleproviderservices, oracle.manageddataaccess.entityframework, version=6.121.2.0, culture=neutral, publickeytoken=89b483f429c47342" /> </providers> </entityframework> <system.codedom> <compilers> <compiler language="c#;cs;csharp" extension=".cs" type="microsoft.codedom.providers.dotnetcompilerplatform.csharpcodeprovider, microsoft.codedom.providers.dotnetcompilerplatform, version=1.0.0.0, culture=neutral, publickeytoken=31bf3856ad364e35" warninglevel="4" compileroptions="/langversion:6 /nowarn:1659;1699;1701" /> <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="microsoft.codedom.providers.dotnetcompilerplatform.vbcodeprovider, microsoft.codedom.providers.dotnetcompilerplatform, version=1.0.0.0, culture=neutral, publickeytoken=31bf3856ad364e35" warninglevel="4" compileroptions="/langversion:14 /nowarn:41008 /define:_mytype=\"web\" /optioninfer+" /> </compilers> </system.codedom> <system.data> <dbproviderfactories> <remove invariant="oracle.manageddataaccess.client" /> <add name="odp.net, managed driver" invariant="oracle.manageddataaccess.client" description="oracle data provider .net, managed driver" type="oracle.manageddataaccess.client.oracleclientfactory, oracle.manageddataaccess, version=4.121.2.0, culture=neutral, publickeytoken=89b483f429c47342" /> </dbproviderfactories> </system.data> <oracle.manageddataaccess.client> <version number="*"> <datasources> <datasource alias="sampledatasource" descriptor="(description=(address=(protocol=tcp)(host=localhost)(port=1521))(connect_data=(service_name=orcl))) " /> </datasources> </version> </oracle.manageddataaccess.client> </configuration>
i using entityframework 6 , not using migration have created table in oracle database , connects oracle connectionstring in server tools section. scaffold , nicely scaffolds creating models. when run runs default page nicely when run specific url of scaffolding data returns following error:
i added 2 references, 1. oracle.manageddataaccess , 2. oracle.manageddataaccess.entityframework after installing odt. wrong pls help....i trying use database tables without doing migrations. in advance.