Fork/Fork.Net/Oreo.Plugins/Oreo.FileMan/DatabaseEngine/Muse.cs

using Oreo.FileMan.Commons;
using Oreo.FileMan.Models;
using SQLite.CodeFirst;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Oreo.FileMan.DatabaseEngine
{
    public class Muse : DbContext
    {
        public Muse()
            : base("DefaultConnection")
        {
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
            modelBuilder.Configurations.AddFromAssembly(typeof(Muse).Assembly);
            if (!File.Exists(R.Files.Db))
            {
                Database.SetInitializer(new MyDbInitializer(Database.Connection.ConnectionString, modelBuilder));
                //var sqliteConnectionInitializer = new SqliteCreateDatabaseIfNotExists<Muse>(modelBuilder);
                //Database.SetInitializer(sqliteConnectionInitializer);}
            }
        }

        public class MyDbInitializer : SqliteDropCreateDatabaseAlways<Muse>
        {
            public MyDbInitializer(string connectionString, DbModelBuilder modelBuilder)
                : base(modelBuilder) { }

            protected override void Seed(Muse context)
            {
                //context.Set<Files>().Add(new Files { FileName = "123" });
                base.Seed(context);
            }
        }
    }
}