Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

oracle instant client and entity framework trouble with configuration

oracle instant client and entity framework trouble with configuration  using -'c#,,oracle,entity-framework,odac'

I'm trying to learn and figure out if it is possible to deploy an MVC, EF, ODAC app to a server that has a previous version of ODP.NET installed. Rather than updating the sever ODP.NET (which I can't), I figured I could use the Oracle Instant Client.

Is this doable?

1) I added these dlls to my project to support Instant Client







2) Next I updated web.config for the dbProviderFactories

    <add name="Oracle Data Provider for .NET"
    description="Oracle Data Provider for .NET"
    type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess,    Version=, Culture=neutral, PublicKeyToken=89b483f429c47342" />

3)  This (afaik) is how to use the Oracle dll in the bin rathre than the GAC

<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" />
    <publisherPolicy apply="no" />

4) Finally my connectionString

    <add name="Entities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=Oracle.DataAccess.Client;
provider connection string=&quot;DATA SOURCE=XXX;PASSWORD=XXX;PERSIST SECURITY INFO=True;USER ID=XXX&quot;" providerName="System.Data.EntityClient" />

This is the error I receive
Unable to find the requested .Net Framework Data Provider.  It may not be installed.

I really appreciate any help here. I'm rather new and have a lot to learn. Thanks in advance. cheers

asked Sep 16, 2015 by kinnari
0 votes

Related Hot Questions

Government Jobs Opening