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