public PublisherDataContext() { #if(DEBUG) var initializer = new DropCreateDatabaseIfModelChanges<PublisherDataContext>(); Database.SetInitializer(initializer); #endif }
public UserDemoContext() : base("mycon") { DropCreateDatabaseIfModelChanges <UserDemoContext> d = new DropCreateDatabaseIfModelChanges <UserDemoContext>(); Database.SetInitializer(d); }
public static ApplicationDbContext Create() { IDatabaseInitializer <ApplicationDbContext> strategy; switch (ConfigurationManager.AppSettings["Database_Initialize_Strategy"]) { case "CreateDatabaseIfNotExists": strategy = new CreateDatabaseIfNotExists <ApplicationDbContext>(); break; case "DropCreateDatabaseAlways": strategy = new DropCreateDatabaseAlways <ApplicationDbContext>(); break; case "DropCreateDatabaseIfModelChanges": strategy = new DropCreateDatabaseIfModelChanges <ApplicationDbContext>(); break; case "MigrateDatabaseToLatestVersion": strategy = new MigrateDatabaseToLatestVersion <ApplicationDbContext, Configuration>(); break; default: strategy = new NullDatabaseInitializer <ApplicationDbContext>(); break; } Database.SetInitializer(strategy); return(new ApplicationDbContext()); }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { IDatabaseInitializer <AggregationContext> addBucket = new DropCreateDatabaseIfModelChanges <AggregationContext>(); Database.SetInitializer <AggregationContext>(addBucket); base.OnModelCreating(modelBuilder); }
public EFContext() : base("Asp_Net_MVC_CS") { var dbInit = new DropCreateDatabaseIfModelChanges <EFContext>(); Database.SetInitializer <EFContext>(dbInit); }
public void DropCreateDatabaseIfModelChanges() { SqlConnection.ClearAllPools(); var initializer = new DropCreateDatabaseIfModelChanges <StagioDbContext>(); Database.SetInitializer(initializer); }
public void DropCreateDatabaseIfModelChanges() { SqlConnection.ClearAllPools(); var initializer = new DropCreateDatabaseIfModelChanges<MiamDbContext>(); // Pour mettre des données non sensibles à la création de la BDdans la BD, utiliser //var initializer = new EfDropCreateIfModelChangesSeeder() Database.SetInitializer(initializer); }
public LocalDatabaseContext(String nameOrConnectionString) : base(nameOrConnectionString) { var dropCreateDatabaseIfModelChanges = new DropCreateDatabaseIfModelChanges <LocalDatabaseContext>(); // Jelenleg nem használt: // var dropCreateDatabaseAlways = new DropCreateDatabaseAlways<LocalDatabaseContext>(); Database.SetInitializer(dropCreateDatabaseIfModelChanges); }
private void Button_Click(object sender, RoutedEventArgs e) { //IDatabaseInitializer<BddContext> init = new CreateDatabaseIfNotExists<BddContext>(); //IDatabaseInitializer<BddContext> init = new DropCreateDatabaseAlways<BddContext>(); IDatabaseInitializer <BddContext> init = new DropCreateDatabaseIfModelChanges <BddContext>(); Database.SetInitializer(init); init.InitializeDatabase(new BddContext()); }
public PAP_CondominioContext() : base("name=PAP_CondominioContext") { //quando houver uma auteracao na base de dados vai apagar e criar de novo DropCreateDatabaseIfModelChanges <PAP_CondominioContext> initializer = new DropCreateDatabaseIfModelChanges <PAP_CondominioContext>(); Database.SetInitializer <PAP_CondominioContext>(initializer); }
public RecyclingBanco() { DropCreateDatabaseIfModelChanges <RecyclingBanco> initializar = new DropCreateDatabaseIfModelChanges <RecyclingBanco>(); Database.SetInitializer <RecyclingBanco>(initializar); //Mostrar no log a instrução //Database.Log = instrucao => System.Diagnostics.Debug.WriteLine(instrucao); }
protected override IUnitOfWorkFactory CreateUnitOfWorkFactory() { var dbInitializer = new DropCreateDatabaseIfModelChanges<DbContext>(); Database.SetInitializer(dbInitializer); return new EntityFrameworkUnitOfWorkFactory( this.GetConnectionString() , this.GetDbModel() ); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); DropCreateDatabaseIfModelChanges<TrailLockerEntities> refresher = new DropCreateDatabaseIfModelChanges<TrailLockerEntities>(); Database.SetInitializer<TrailLockerEntities>(refresher); }
public void DropCreateDatabaseIfModelChanges() { SqlConnection.ClearAllPools(); var initializer = new DropCreateDatabaseIfModelChanges <MiamDbContext>(); // Pour mettre des données non sensibles à la création de la BDdans la BD, utiliser //var initializer = new EfDropCreateIfModelChangesSeeder() Database.SetInitializer(initializer); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); DropCreateDatabaseIfModelChanges <TrailLockerEntities> refresher = new DropCreateDatabaseIfModelChanges <TrailLockerEntities>(); Database.SetInitializer <TrailLockerEntities>(refresher); }
public ComicReaderDbContext(string connectionString = "ComicReaderDb", IDatabaseInitializer <ComicReaderDbContext> initializer = null) : base(connectionString) { if (initializer == null) { //initializer = new CreateDatabaseIfNotExists<ComicReaderDbContext>(); initializer = new DropCreateDatabaseIfModelChanges <ComicReaderDbContext>(); } System.Data.Entity.Database.SetInitializer(initializer); }
public static DbContext Setup(bool loadTestData = true) { DropCreateDatabaseIfModelChanges <HammondsIBMSContext> strategy = null; if (loadTestData) { strategy = new InitialiseHammondsDb(); } else { strategy = new InitialiseHammondsNoTestDataDb(); } Database.SetInitializer <HammondsIBMSContext>(strategy); //Database.SetInitializer<HammondsIBMS_DB>(new CreateDatabaseIfNotExists<HammondsIBMS_DB>()); return(new HammondsIBMSContext()); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); //IDatabaseInitializer<EasyGradeManagerContext> init = new DropCreateDatabaseAlways<EasyGradeManagerContext>(); IDatabaseInitializer <EasyGradeManagerContext> init = new DropCreateDatabaseIfModelChanges <EasyGradeManagerContext>(); Database.SetInitializer(init); init.InitializeDatabase(new EasyGradeManagerContext()); HttpConfiguration config = GlobalConfiguration.Configuration; config.Formatters.JsonFormatter .SerializerSettings .ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore; config.Formatters.JsonFormatter .SerializerSettings .DateFormatString = "yyyy-MM-dd"; }
public void Configuration(IAppBuilder app) { try { // check if db needs to be deleted var initializer = new DropCreateDatabaseIfModelChanges <SsnDbContext>(); Database.SetInitializer(initializer); initializer.InitializeDatabase(new SsnDbContext()); } catch (Exception ex) { Global.Logger.Error(ex.ToString()); } app.UseCookieAuthentication(new CookieAuthenticationOptions { AuthenticationType = DefaultAuthenticationTypes.ApplicationCookie, LoginPath = new PathString("/Authentication/Login") }); }
public static void Load() { IDatabaseInitializer <MyContext> dbInitializer = null; if (DbContext.Database.Exists()) { //如果model有改变 dbInitializer = new DropCreateDatabaseIfModelChanges <MyContext>(); } else { //总是先删除然后再创建 dbInitializer = new DropCreateDatabaseAlways <MyContext>(); } dbInitializer.InitializeDatabase(DbContext); if (!DbContext.User.Any()) { DbContext.User.Add(new UserModel { Name = "admin", PassWord = "******", RoleName = "Admin" }); } if (!DbContext.Role.Any()) { DbContext.Role.Add(new RoleModel { Name = "Admin", Permission = "RoleAdd,RoleEdit,RoleDelete,RoleManage,UserAdd,UserEdit,UserDelete,UserManage,UserPassWordReset,HospitalAdd,HospitalEdit,HospitalDelete,HospitalManage,VersionAdd,VersionEdit,VersionDelete,VersionManage,UpLoadBaseModelFile,UpLoadFile,RoleGroup,UserGroup,HospitalGroup,VersionGroup,UpLoadGroup", CreateUer = "admin", CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Status = "1", ManageHospital = "ALL" }); } DbContext.SaveChanges(); }
public AyanaContext() : base("mynew") { DropCreateDatabaseIfModelChanges <AyanaContext> d = new DropCreateDatabaseIfModelChanges <AyanaContext>(); Database.SetInitializer <AyanaContext>(d); }
public void InitializeDb() { var initializer = new DropCreateDatabaseIfModelChanges<SurveyorContext>(); using (var db = new SurveyorContext()) { initializer.InitializeDatabase(db); DbSeeder.Seed(db); db.SaveChanges(); } }
public UserContext() : base("Newcon") { DropCreateDatabaseIfModelChanges <UsersContext> d = new DropCreateDatabaseIfModelChanges <UsersContext>(); Database.SetInitializer <UsersContext>(d); }
public CustomerContext() : base("mycon") { DropCreateDatabaseIfModelChanges <CustomerContext> d = new DropCreateDatabaseIfModelChanges <CustomerContext>(); Database.SetInitializer <CustomerContext>(d); }
public GranaContext() : base("EF") { DropCreateDatabaseIfModelChanges <EfContext> initializer = new DropCreateDatabaseIfModelChanges <EfContext>(); Database.SetInitializer(initializer); }
protected void Application_Start(object sender, EventArgs e) { var dbInitializer = new DropCreateDatabaseIfModelChanges <FrequentFlyersContext>(); dbInitializer.InitializeDatabase(new FrequentFlyersContext(BlueYonder.FrequentFlyerService.Implementation.FrequentFlyerService.ConnectionName)); }
public Context() : base() { var initializer = new DropCreateDatabaseIfModelChanges <Context>(); Database.SetInitializer(initializer); }
static void Main(string[] args) { var dbInitializer = new DropCreateDatabaseIfModelChanges <MyDbContext>(); dbInitializer.InitializeDatabase(new MyDbContext()); UserDetailsImpl imp = new UserDetailsImpl(); UserDetailsDAO dao = new UserDetailsImpl(); int i; string ch = "y"; while (!ch.Equals("n")) { Console.WriteLine("======================\n1. Add User \n2. Delete User \n3. Update User \n4. Get All User \n5. Get Data by ID \n======================"); Console.Write("\nEnter your Choice : "); i = Int32.Parse(Console.ReadLine()); if (i < 6) { switch (i) { case 1: UserDetails u = new UserDetails(); Console.Write("\nEnter Name : "); u.Name = Console.ReadLine(); Console.Write("Enter Age : "); u.Age = Int32.Parse(Console.ReadLine()); Console.Write("\nEnter Email : "); u.UserEmail = Console.ReadLine(); Console.Write("\nEnter Password : "******"\nEnter Mobile : "); u.UserMobile = long.Parse(Console.ReadLine()); Console.Write("\nEnter Adress : "); u.UserAdress = Console.ReadLine(); Console.Write("\nEnter Role : "); u.UserRole = Console.ReadLine(); Console.Write("\nEnter Status : "); u.UserStatus = Console.ReadLine(); dao.addUser(u); break; case 2: string delChoice = "y"; while (!delChoice.Equals("n")) { Console.Write("\nEnter ID to Delete: "); UserDetails ud = new UserDetails(); ud.UserId1 = Int32.Parse(Console.ReadLine()); ud = dao.getSqlDataByUserId(ud); Console.WriteLine(ud.UserId1 + "\t" + ud.Name + "\t" + ud.Age + "\t" + ud.UserAdress + "\t" + ud.UserEmail + "\t" + ud.UserPassword + "\t" + ud.UserMobile + "\t" + ud.UserRole + "\t" + ud.UserStatus); Console.Write("Do you wanna delete this record? (y/n) : "); string mchoice = Console.ReadLine(); if (mchoice == "y" || mchoice == "Y") { dao.removeUser(ud); Console.WriteLine("Data deleted successfully."); Console.Write("Delete more? (y/n) : "); delChoice = Console.ReadLine(); } else if (mchoice == "n" || mchoice == "N") { continue; } else { Console.WriteLine("Invalid input"); } } break; case 3: UserDetails uu = new UserDetails(); Console.Write("Enter the User ID to update data : "); uu.UserId1 = Int32.Parse(Console.ReadLine()); Console.Write("New Name : "); uu.Name = Console.ReadLine(); //Console.Write("New ID : "); // uu.UserId1 = Int32.Parse(Console.ReadLine()); Console.Write("New Age : "); uu.Age = Int32.Parse(Console.ReadLine()); Console.Write("New Adress : "); uu.UserAdress = Console.ReadLine(); Console.Write("New Email : "); uu.UserEmail = Console.ReadLine(); Console.Write("New Password : "******"\nNew Mobile : "); uu.UserMobile = long.Parse(Console.ReadLine()); Console.Write("New Role : "); uu.UserRole = Console.ReadLine(); Console.Write("New Status : "); uu.UserStatus = Console.ReadLine(); dao.updateUser(uu); break; case 4: List <UserDetails> uall = dao.getAllUsers(); Console.WriteLine("\n\nID\tName\tAge\n==================="); foreach (UserDetails ur in uall) { Console.WriteLine(ur.UserId1 + "\t" + ur.Name + "\t" + ur.Age + "\t" + ur.UserAdress + "\t" + ur.UserEmail + "\t" + ur.UserPassword + "\t" + ur.UserMobile + "\t" + ur.UserRole + "\t" + ur.UserStatus); Console.WriteLine("-------------------"); } break; case 5: UserDetails x = new UserDetails(); UserDetails y = new UserDetails(); Console.WriteLine("1. Get data by ID \n2. Get data by User ID"); int choice = Int32.Parse(Console.ReadLine()); if (choice == 1) { Console.Write("Enter ID: "); x.Id = Int32.Parse(Console.ReadLine()); y = dao.getSqlDataById(x); Console.WriteLine(y.UserId1 + "\t" + y.Name + "\t" + y.Age + "\t" + y.UserAdress + "\t" + y.UserEmail + "\t" + y.UserPassword + "\t" + y.UserMobile + "\t" + y.UserRole + "\t" + y.UserStatus); } else if (choice == 2) { Console.WriteLine("Enter User ID : "); x.UserId1 = Int32.Parse(Console.ReadLine()); y = dao.getSqlDataByUserId(x); Console.WriteLine(y.UserId1 + "\t" + y.Name + "\t" + y.Age + "\t" + y.UserAdress + "\t" + y.UserEmail + "\t" + y.UserPassword + "\t" + y.UserMobile + "\t" + y.UserRole + "\t" + y.UserStatus); } else { Console.WriteLine("Invalid Option.....\nPlease try again."); continue; } break; } } else { Console.WriteLine("\nInvalid Option.....\nPlease try again.\n"); continue; } Console.Write("\n\nRun prrogramme again? (y/n) : "); ch = Console.ReadLine(); Console.WriteLine("\n\n"); } }
public GranaContext() { DropCreateDatabaseIfModelChanges <GranaContext> init = new DropCreateDatabaseIfModelChanges <GranaContext>(); Database.SetInitializer <GranaContext>(init); }
public InitAdminController() { db = new ApplicationDbContext(); dbInit = new DropCreateDatabaseIfModelChanges <DbContext>(); }
public SimpleFormContext() { DropCreateDatabaseIfModelChanges <SimpleFormContext> initializer = new DropCreateDatabaseIfModelChanges <SimpleFormContext>(); Database.SetInitializer <SimpleFormContext>(initializer); }