CODEWITHSUNDEEP
c#oracle-databaseentity-framework
Mehdi Souregi
Mehdi Souregi

Reputation: 3265

Oracle connection : Unable to find the requested .Net Framework Data Provider. It may not be installed

I am new to Oracle, I've installed Oracle Developer Tools for Visual Studio, and after that I've added a new ADO.NET Entity Data Model, and finally i've tried to use entity framework like i used to do with sql server : 

using(DbEntities dbentity = new DbEntities())
{
    var test = dbentity.mytable.ToList()
}

I am getting this error :

Unable to find the requested .Net Framework Data Provider. It may not be installed.

I've read about DbProviderFactories, but i don't know which provider i should use and its right paramaters. Besides I don't have the Oracle.DataAccess.dll referenced on my project.

I am stack at this point for hours, please do not mark as duplicate if you are not sure about the solution

Upvotes: 0

Views: 3671

Answers (1)

Mad Myche
Mad Myche

Reputation: 1075

Switching from one type of database server to another often requires changing the client package you use to connect with it.

Sql Server would generally reference `System.Data.SqlClient'

Net Framework does contain the System.Data.OracleClient, but it has been deprecated. From what I understand; you would want to use the ODP.Net package: Official Oracle ODP.NET, Managed Driver.

Upvotes: 2

Related Questions