Entity Framework 6 with SQL Server Compact 4.0

entity-framework sql-server-ce
tafkab76 picture tafkab76 · Oct 31, 2013 · Viewed 14.4k times · Source

I'm (still) trying to follow an online video tutorial on how to use the Entity Framework with the code-first approach. I am as far as my EDM validates fine and it's time to actually build the database. The instructor uses a SQL Server and obviously the database is created automatically when the first query command (ToList()) against an DbContext-object.

As I am planning to use a SQL Server Compact file-based database in a future application, I tried to reproduce the tutorial's example with SQL Server Compact 4.0. I installed the NuGet packages "EntityFramework.SqlServerCompact" and "Micrososft SQL Server Compact Edition". Obviously this leads to a new provider entry in the app.config:

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

But when I run the first query command, I get the error message

Migrations is enabled for context 'DataModelContext' but the database does not exist or contains no mapped tables. Use Migrations to create the database and its tables, for example by running the 'Update-Database' command from the Package Manager Console.

When I run Update-Database I get the message:

No pending explicit migrations.
Applying automatic migration: 201310311356014_AutomaticMigration.
Running Seed method.

and no database is created, at least the program still quits with above error message.

Doesn't EF create a SQL Server CE database automatically? If so, how do I connect a manually created DB with my app?

Answer

tafkab76 picture tafkab76 · Nov 1, 2013

The problem could be solved by manually adding a Connection string to the app.config-file, at the end of the <configuration>-tag:

  <connectionStrings>
    <add name="DataModelContext"
         providerName="System.Data.SqlServerCe.4.0"
         connectionString="Data Source=C:\Users\sblxxx\Documents\Visual Studio 2012\Projects\Pluralsight\EF5\CodeFirst\db\cfdb.sdf"/>
  </connectionStrings>

Related questions

How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)

I'm working with the Code First feature of Entity Framework and I'm trying to figure out how I can specify the column data types that should be created when the database is auto-generated. I have a simple model: public class …

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

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="…

Read More
Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider

In my project, I use SQL CE 3.5 database with entity framework and followed this article but i have this exception : Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the …

Read More