UNABLE TO FIND THE REQUESTED .NET FRAMEWORK DATA PROVIDER. IT MAY NOT BE INSTALLED

Sachin Singh

Total Post:26

Points:182
Posted by  Sachin Singh
 1680  View(s)
Ratings:
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.
  1. Anupam Mishra

    Post:135

    Points:949
    Re: Unable to find the requested .Net Framework Data Provider. It may not be installed

    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!