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

I got the following error when I used sqlce 4.0 with entityframework 6.0

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

My app.config looks like this 

....
<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 tried re-installing EF 6. But no avail.

Any clue on this would be much appreciable.

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

After installing the EntityFramework.SqlServerCompact nuget package, check that your app.config contains the following (as 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 can leave the line for SqlClient even though you don't really need it.)

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

Popular Answer

ErikEJ has pointed this out, but I'd like to highlight the fact, you MUST remember to install the Nuget package

EntityFramework.SqlServerCompact

I tried following the recommended answer, but didn't realise I didn't have the required NuGet package the App.config was referencing.

David Chiew

Related Questions

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

in EF5 or less, all ok. in EF6, you need to use mysql connector 6.8.x, and add DbConfigurationTypeAttribute to you DbContext:...[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))] public class DemoContext : DbContext{} ...which MySqlEFConfiguration is in MySql.Data.Entity.EF6.dll in 6.8.x. Have a try!
entity-framework mysql
asked by AlexanderYao

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

You've added EF to a class library project. You also need to add it to the project that references 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 problem as the one presented in the question ...No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'..., the error has the following message:..."The ADO.NET provider with invariant name 'System.Data.SqlClient' is either not registered in the machine or application config file, or c...
.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 includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. 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'.

We are using EntityFramework 6 with Code First. We have a console app that has no reference to EntityFramework but reads the connection string from its App.config. It calls the DatabaseInitializationUtilities assembly passing the connection string as a parameter. ...DatabaseInitializationUtilities has the reference to EF6 (EntityFramework and Ent...
.net asp.net c# entity-framework-6 sql-server
asked by Dewey

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

None of the posts on here has seemed to address this specific version of my error but I may just be missing something... ...Situation:...MVC website consumes a WCF service. Data is saved in the WCF service. Both are running ... <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, V...
.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"

That was a super-great answer zhnglicho! ...Another option, aside from placing the providers and DbProviderFactories into the app.config or web.config, is to code your ProviderFactories and use it in your implementation of DbContext....Usings:...using System.Data.Entity; using System.Data.Entity.Core.Common; using System.Data.Entity.ModelConfigurat...
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 got this error but for me, it was something entirely different. I was able to solve it by looking at only ...Unable to find the requested .Net Framework Data Provider... and ...finding this answer.......I then had to edit:...C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config ...And:...C:\Windows\Microsoft.NET\Framework\v4.0.303...
.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

I am trying to port an application from EF3.5 using MS-SQL Server to EF6 using SQLite. Currently the application runs fine on my development machine but as soon as I try to deploy it somewhere else (in this case my Installation-Test-VM), it won't load. Instead I get an exception stating that the ADO.NET Provider with the invariant name 'System.Data...
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