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

Total Post:26

Points:182
Posted on    March-16-2016 12:25 AM

 ASP.Net C#  ASP.Net  ASP.NET MVC  Database Connection  Routing 
Ratings:


 1 Reply(s)
 534  View(s)
Rate this:
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:


Please anyone give me any solution.
Thank you.


Anupam Mishra

Total Post:135

Points:949
Posted on    March-17-2016 11:43 PM

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.


Don't want to miss updates? Please click the below button!

Follow MindStick