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; }