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

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.
Last updated:3/17/2016 11:43:24 PM

1 Answers

Anupam Mishra
Anupam Mishra

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.

Answer