public static void ClearDatabase()
{
var context = new SQLServerDbContext();
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
public DataFactory(SQLServerDbContext sqlDbContext, PostgreDbContext postgreDbContext, SqliteDbContext sqliteDbContext)
{
Guard.WhenArgument(sqlDbContext, "sqlDbContext").IsNull().Throw();
this.sqlDbContext = sqlDbContext;
Guard.WhenArgument(postgreDbContext, "postgreDbContext").IsNull().Throw();
this.postgreDbContext = postgreDbContext;
Guard.WhenArgument(sqliteDbContext, "sqliteDbContext").IsNull().Throw();
this.sqliteDbContext = sqliteDbContext;
}
protected override void Seed(SQLServerDbContext context)
{
context.Genders.AddOrUpdate(
g => g.Name,
new Gender {
Name = "Male"
},
new Gender {
Name = "Female"
},
new Gender {
Name = "Undefined"
});
// var sofia = new Municipality { Name = "Sofia" };
// var plovdiv = new Municipality { Name = "Ploviv" };
// var varna = new Municipality { Name = "Varna" };
// var tarnovo = new Municipality { Name = "Veliko Tarnovo" };
//
// context.Municipalities.AddOrUpdate(m => m.Name,
// sofia,
// plovdiv,
// varna,
// tarnovo
// );
//
// context.Towns.AddOrUpdate(t => t.Name,
// new Town
// {
// Name = "Sofia",
// Municipality = sofia
// },
// new Town
// {
// Name = "Pernik",
// Municipality = sofia
// },
// new Town
// {
// Name = "Plovdiv",
// Municipality = plovdiv
// },
// new Town
// {
// Name = "Varna",
// Municipality = varna
// },
// new Town
// {
// Name = "Veliko Tarnovo",
// Municipality = tarnovo
// });
}
public static bool TransferData()
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
try
{
var context = new SQLServerDbContext();
context.Database.SetCommandTimeout(10 * 60);
var sqlFiles = Directory.GetFiles(@"C:\Temp\juveel\scripts", "*.sql").OrderBy(x => x);
foreach (string file in sqlFiles)
{
context.Database.ExecuteSqlCommand(File.ReadAllText(file, Encoding.GetEncoding(1257))); //Encoding.Default
}
}
catch (IOException e)
{
return(false);
}
return(true);
}
public ExamsAPIController(SQLServerDbContext context)
{
_context = context;
}
public LawsAPIController(SQLServerDbContext dbContext)
{
_context = dbContext;
}
public TraficSignsAPIController(SQLServerDbContext dbContext)
{
_context = dbContext;
}
public QuestionsAPIController(SQLServerDbContext context)
{
_context = context;
}
