InMemorySqliteDatabaseInitializer

InMemorySqliteDatabaseInitializer.cs

    public class InMemorySqliteDatabaseInitializer<TContext> : SqliteInitializerBase<TContext>
        where TContext : DbContext
    {
        public InMemorySqliteDatabaseInitializer(DbModelBuilder modelBuilder)
            : base(modelBuilder)
        {
        }


        public override void InitializeDatabase(TContext context)
        {
            InitializeDatabaseInMemory(context);
        }


        void InitializeDatabaseInMemory(TContext context)
        {
            var model = ModelBuilder.Build(context.Database.Connection);

            using (var transaction = context.Database.BeginTransaction())
            {
                try
                {
                    var sqliteDatabaseCreator = new SqliteDatabaseCreator();
                    sqliteDatabaseCreator.Create(context.Database, model);
                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                    throw;
                }
            }

            using (var transaction = context.Database.BeginTransaction())
            {
                try
                {
                    Seed(context);
                    context.SaveChanges();
                    transaction.Commit();
                }
                catch (Exception)
                {
                    transaction.Rollback();
                    throw;
                }
            }
        }
    }