No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'

c#-4.0 entity-framework sql-server-ce

Question

When I combined SQLCE 4.0 with EntityFramework 6.0, I received the following error.

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'

This is how my app.config looks.

....
<configSections>
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" requirePermission="false" />
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --></configSections>
 <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" >
      <parameters>
        <parameter value =" System.Data.SqlServerCe.4.0" />
      </parameters>
    </defaultConnectionFactory>
    <!--providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers-->
  </entityFramework>
  <connectionStrings>
    <add name="FbMultipleInsOrderContainer" connectionString="metadata=res://*/FbMultipleInsOrder.csdl|res://*/FbMultipleInsOrder.ssdl|res://*/FbMultipleInsOrder.msl;provider=System.Data.SqlServerCe.4.0;provider connection string=&quot;data source=|DataDirectory|\FBMultipleOrderSync.sdf&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
...

I attempted to reinstall EF 6. but in vain.

Any information on this would be greatly appreciated.

1
35
11/6/2013 7:42:22 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Check that your app.config contains the following after installing the EntityFramework.SqlServerCompact nuget package (per @ErikEJ's comment above):

<providers>
  <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
  <provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" />
</providers>

(You don't actually need the line for SqlClient, but you can leave it.)

57
6/13/2014 12:46:42 PM

Popular Answer

ErikEJ has already brought this up, but I want to emphasize that you really MUST install the Nuget package.

EntityFramework.SqlServerCompact

I attempted to implement the suggested solution but failed since I was missing the NuGet package that the App.config was referring.

David Chiew

Related Questions

No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider

All right in EF5 or less. Use MySQL connector 6.8.x in EF6 and give your DbContext the DbConfigurationTypeAttribute:...[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))] public class DemoContext : DbContext{} ...whose MySqlEFConfiguration is contained in 6.8.x's MySql.Data.Entity.EF6.dll. Give it a go!
entity-framework mysql
asked by AlexanderYao

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'

An EF project for a class library has been added. Additionally, you must include it in the project that refers to it (your console app, website or whatever).
entity-framework
asked by Clément Picou

Entity Framework ADO.NET Sql.Data.Client provider not found

I have a similar issue to the one raised in the question ...System.Data.SqlClient is an invariant name for the ADO.NET provider, yet there was no Entity Framework provider discovered for it...., and the error message reads as follows:..."The machine or application configuration file does not list the ADO.NET provider with the invariant name "System...
.net c# entity-framework
asked by MigLuev

No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'

Try to use ODAC 12c Release 3, which supports Managed Driver XML DB, NuGet,.NET Framework 4.5.2, and Entity Framework 6 Code First and Code First Migrations. As per...http://www.oracle.com/technetwork/topics/dotnet/whatsnew/index.html
.net asp.net-mvc-4 c# entity-framework oracle
asked by Wasef Anabtawi

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'.

EntityFramework 6 is what we're using with Code First. A console app that we have reads the connection string from its App.config but does not mention EntityFramework. It uses the connection string as an argument when calling the DatabaseInitializationUtilities assembly....The reference to EF6 is found in DatabaseInitializationUtilities (EntityFram...
.net asp.net c# entity-framework-6 sql-server
asked by Dewey

No Entity Framework provider found ... with invariant name 'System.Data.SqlClient'

ZZZ_tmp
.net asp.net-mvc c# entity-framework wcf
asked by MetalPhoenix

ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' could not be loaded

The Entity Framework provider type 'System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is availab...
.net breeze entity-framework sql-server-ce-4 visual-studio-2013
asked by Oldergit

Unable to determine the provider name for provider factory of type "System.Data.Sqlite.SqliteFactory"

ZZZ_tmp
c# entity-framework entity-framework-6 sqlite visual-studio-2013
asked by PixelSyndicate

ADO.NET provider with invariant name 'System.Data.SqlClient;' cannot be found (Entity Framework MVC)

I experienced same error, but it was completely different for me. I was able to figure it out by focusing exclusively on...Unable to find the requested .Net Framework Data Provider... and 8 to ZZZ....Later, I had to edit:...C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config ...And:...C:\Windows\Microsoft.NET\Framework\v4.0.30319\...
.net asp.net asp.net-mvc entity-framework entity-framework-6
asked by Ogglas

System.Data.SQLite ADO.NET Provider cannot be loaded on non development machine

ZZZ_tmp
c# dll entity-framework-6 sqlite
asked by ChNissen

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow