Generate SQL CE database from EF Code-First DbContext class

.net code-first ef-code-first entity-framework sql-server-ce


I've defined a set of classes in the style of Entity Framework Code-First conventions and annotated the class properties with System.ComponentModel.DataAnnotations attributes.

Now I want to generate a SQL Server Compact Edition (SCSE) (4.0) database from this code.

What code is needed to do this and what assemblies need to be imported?

So far I've imported the C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Desktop{System.Data.SqlServerCe.dll,System.Data.SqlServerCe.Entity\System.Data.SqlServerCe.Entity.dll} dll files.

Any pointers appreciated. Articles and whatnot.

1/30/2011 10:48:00 AM

Accepted Answer

I found the solution. The critical thing is this line of code:

DbDatabase.DefaultConnectionFactory = new 

Here's a full sample:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Proto
    using System.Data;
    using System.Data.Entity;
    using System.Data.Entity.Database;
    using System.Data.SqlServerCe;
    using System.ComponentModel.DataAnnotations;

    class Program
        static void Main(string[] args)
            DbDatabase.DefaultConnectionFactory = new 
                         new DropCreateDatabaseIfModelChanges<ProtoCatalog>()

            using (var db = new ProtoCatalog())
                var user = new User
                    Name = "bob",
                    Password = "123",
                    Creation = DateTime.Now,
                    PrimaryEmailAddress = ""




    public class ProtoCatalog : DbContext
        public DbSet<User> Users { get; set; }

    public class User
        [Key, StringLength(50)]
        public string Name { get; set; }

        [Required, StringLength(100)]
        public string Password { get; set; }

        [Required, StringLength(320)]
        public string PrimaryEmailAddress { get; set; }

        public string SecondaryEmailAddress { get; set; }

        public DateTime Creation { get; set; }

        public bool Active { get; set; }

The API will probably change between EF Code-First CTP 5 and RTM though, but this is how it's done now.

I've made a small blog post about it.

5/28/2012 11:05:52 AM

Popular Answer

Another way of providing the DefaultConnectionProvider is by adding it in app.config.

  <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
      <parameter value="System.Data.SqlServerCe.4.0" />

Related Questions


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