forum

Home / DeveloperSection / Forums / Unable to find the requested .Net Framework Data Provider. It may not be installed

Ask Question

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

Sachin Singh329816-Mar-2016
Hi Everyone,
I want to add Sql server 2012 in my application and when i want to run my application it will give a following error:
Unable to find the requested .Net Framework Data Provider. It may not be installed

Please anyone give me any solution.
Thank you.
asp.netc# asp.net asp.net mvc database connection routing 
Updated on 17-Mar-2016
Sachin Singh

Sachin Singh

Follow

Can you answer this question?

Answer

1 Answers

Anupam Mishra

Anupam Mishra

17-Mar-2016
Hi Sachin,

For solving above problem you should go the below link in your local computer


\Windows\Microsoft.net\Framework\v****\machine.config


And add  in the section of <system.data>.


<system.data>
    <DbProviderFactories> <add name="Odbc Data Provider" invariant="System.Data.Odbc"/>
     <add name="OleDb Data Provider" invariant="System.Data.OleDb"/>
     <add name="OracleClient Data Provider" invariant="System.Data” />
     <add name="SqlClient Data Provider" invariant="System.Data” />
     <add name="IBM DB2 for i .NET Provider" invariant="IBM.Data/”>
     <add name="Microsoft SQL Server Compact Data Provider"/>     
    </DbProviderFactories>
</system.data>

 

After that remove <DbProviderFactories/> empty tag.


Or , you can also solve the issue by nuGet

 

Go to Tools > Library Package Manager > Manage NuGet Packages For Solution

In the dialog, search for "EntityFramework.SqlServerCompact". You'll find a package

with the description "Allows SQL Server Compact 4.0 to be used with Entity

Framework." Install this package.

Liked By