WeblogContext GetContext() { var options = new DbContextOptionsBuilder <WeblogContext>() .UseSqlServer(ConnectionString) .Options; var ctx = new WeblogContext(options); WeblogDataImporter.EnsureWeblogData(ctx, "server=.;database=Weblog;integrated security=true;"); return(ctx); }
public bool ImportOldWebLog(string oldWeblogConnectionString) { var connStr = Context.ConnectionString; var sql = new SqlDataAccess(connStr); int res = sql.ExecuteNonQuery("drop table Comments"); res = sql.ExecuteNonQuery("drop table Posts"); res = sql.ExecuteNonQuery("drop table Users"); res = sql.ExecuteNonQuery("drop table Weblogs"); //if (res < 0) //{ // SetError(sql.ErrorMessage); // return false; //} return(WeblogDataImporter.EnsureWeblogData(Context, "server=.;database=weblog;integrated security=true")); }