Create SQLite database using Entity Framework

Question

I am trying to create my first database. I see countless posts on creation being done using existing database and a config file. What I am trying to achieve though, is to create database from code and also do initialization inside code behind, without a config file.

I have the following inside my MyContext class:

   public MyContext() : base("MyDB") 
{
   DatabaseConfiguration _DBConfig = new DatabaseConfiguration();
}

    public DbSet<MyObject> MyObject { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions
            .Remove<PluralizingTableNameConvention>();
    }

Assuming that whenever I create an instance of MyContext, I should get a Database created if such does not exist. But no file gets created.

Initialization is done as following:

class DatabaseConfiguration : DbConfiguration
{
    public DatabaseConfiguration()
        {
            SetProviderFactory("System.Data.SQLite", SQLiteFactory.Instance);
            SetProviderFactory("System.Data.SQLite.EF6", SQLiteProviderFactory.Instance);
            SetProviderServices("System.Data.SQLite", (DbProviderServices)SQLiteProviderFactory.Instance.GetService(typeof(DbProviderServices)));
        }
}

I am using newest versions of SQLite and EF6 from NuGet.

If I recall correctly, the database is not actually created until you need it. I.e. populate it. — Der Kommissar
– Der Kommissar, Commented Apr 27, 2015 at 19:28
How are you telling your context to use DatabaseConfiguration? Simply declaring an local variable in the constructor won't do it. — mason
– mason, Commented Apr 27, 2015 at 19:28
@mason look closer into what is happening inside the constructor, those are explicit provider settings being executed. — SELJI
– SELJI, Commented Apr 28, 2015 at 17:33

mason · Accepted Answer · 2015-04-28 17:37:25Z

2

You think you are telling it to use your DatabaseConfiguration, but you're not. Simply declaring a local variable in your constructor doesn't tell the context to use that configuration. You can tell it with the DbConfigurationType attribute.

[DbConfigurationType(typeof(DatabaseConfiguration))] 
public class MyContext : DbContext
{
    public MyContext() : base("MyDB") 
    {
    }

    public DbSet<MyObject> MyObject { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
    }
}

answered Apr 28, 2015 at 17:37

mason

32.8k12 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

T N · Accepted Answer · 2015-04-27 19:46:11Z

0

So far as I know, Entity Framework doesn't support creating database + tables for SQLite. You can create a database template by external tool then run manual migrations as suggested in this post for creating or updating database schema.

answered Apr 27, 2015 at 19:46

T N

4065 silver badges13 bronze badges

1 Comment

Snail Over a year ago

Unfortunately, given link is not valid anymore

Collectives™ on Stack Overflow

Create SQLite database using Entity Framework

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related