public static bool InitilizeDatabase(SupportedDatabases database, string connectionString)
{
var builder = new DbContextOptionsBuilder <NccDbContext>();
switch (database)
{
case SupportedDatabases.MSSQL:
builder.UseSqlServer(SetupHelper.ConnectionString, opt => { opt.MigrationsAssembly("DamaCoreCMS.Framework"); opt.MigrationsHistoryTable(SetupHelper.TablePrefix + "ef_migration_history"); });
break;
case SupportedDatabases.MsSqlLocalStorage:
break;
case SupportedDatabases.MySql:
builder.UseMySql(SetupHelper.ConnectionString, opt => { opt.MigrationsAssembly("DamaCoreCMS.Framework"); opt.MigrationsHistoryTable(SetupHelper.TablePrefix + "ef_migration_history"); });
break;
case SupportedDatabases.SqLite:
builder.UseSqlite(SetupHelper.ConnectionString, opt => { opt.MigrationsAssembly("DamaCoreCMS.Framework"); opt.MigrationsHistoryTable(SetupHelper.TablePrefix + "ef_migration_history"); });
break;
case SupportedDatabases.PgSql:
break;
}
//builder.UseSqlite(connectionString, options => options.MigrationsAssembly("DamaCoreCMS.Framework"));
var dbContext = new NccDbContext(builder.Options);
dbContext.Database.Migrate();
return(dbContext.Database.EnsureCreated());
}
public NccDbContext CreateDbContext(string[] args)
{
SetupHelper.LoadSetup();
var opts = SetupHelper.GetDbContextOptions();
var nccDbConetxt = new NccDbContext(opts);
return(nccDbConetxt);
}
public NccDbContext Create(DbContextFactoryOptions options)
{
SetupHelper.LoadSetup();
var opts = SetupHelper.GetDbContextOptions();
var nccDbConetxt = new NccDbContext(opts);
return(nccDbConetxt);
}