public static void BooksDBCreate()
{
var dbInitializer = new BooksDBInitializer();
using (var db = dbInitializer.CreateDbContext(null))
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
}
}
public static void ChangeDBCollate()
{
var dbInitializer = new BooksDBInitializer();
using (var db = dbInitializer.CreateDbContext(null))
{
db.Database.ExecuteSqlRaw("ALTER DATABASE CURRENT COLLATE Cyrillic_General_CI_AS");
SqlConnection.ClearAllPools();
db.SaveChanges();
}
}
public static void FillDbWithSqlScript()
{
var dbInitializer = new BooksDBInitializer();
using (var db = dbInitializer.CreateDbContext(null))
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
var script = File.ReadAllText(_WorkPathToSQLScript, Encoding.Default);
var parts = script.Split(new string[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);
foreach (var part in parts)
{
db.Database.ExecuteSqlRaw(part);
}
db.SaveChanges();
dbContextTransaction.Commit();
}
}
}