public static CFAContext GetContext() { //EffortProviderConfiguration.RegisterProvider(); var connection = DbConnectionFactory.CreateTransient(); CFAContext context = new CFAContext(connection, true); Database.SetInitializer(new DropCreateDatabaseAlways <CFAContext>()); DataSeeder.SeedData(context); return(context); }
protected override void Seed(CFAContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. //context.Roles.AddOrUpdate(role => role.Name, // new Role { Key = Guid.NewGuid(), Name = "Admin" }, // new Role { Key = Guid.NewGuid(), Name = "Employee" }, // new Role { Key = Guid.NewGuid(), Name = "Affiliate" } // ); DataSeeder.SeedData(context); }
public DbContextTest() { CFAContext context = Db.GetContext(); _db = new Repository(context); }
public static void SeedData(CFAContext _dbContext) { // add Action, Controller IRepository repository = new Repository(_dbContext); IQueryable <CFA.Domain.Entities.Action> existingActions = repository.GetAll <CFA.Domain.Entities.Action>(); if (existingActions.IsEmpty()) { IList <CFA.Domain.Entities.Action> actions = Seed.GetActions(); repository.AddRange(actions); repository.Save(); } IQueryable <Controller> existingControllers = repository.GetAll <Controller>(); if (existingControllers.IsEmpty()) { IList <Controller> controllers = Seed.GetControllers(); repository.AddRange(controllers); repository.Save(); } // add ControllerAction IQueryable <ControllerAction> existingControllerActions = repository.GetAll <ControllerAction>(); if (existingControllerActions.IsEmpty()) { IQueryable <Controller> addedControllers = repository.GetAll <Controller>(); IQueryable <CFA.Domain.Entities.Action> addedActions = repository.GetAll <CFA.Domain.Entities.Action>(); IList <ControllerAction> controllerActions = Seed.GetControllerActions(addedControllers, addedActions); repository.AddRange(controllerActions); repository.Save(); } IQueryable <Right> existingRights = repository.GetAll <Right>(); if (existingRights.IsEmpty()) { IQueryable <ControllerAction> cas = repository.GetAll <ControllerAction>(); IList <Right> rights = Seed.GetRights(cas); repository.AddRange(rights); repository.Save(); } IQueryable <Role> existingRoles = repository.GetAll <Role>(); if (existingRoles.IsEmpty()) { IQueryable <Right> addedRights = repository.GetAll <Right>(); IList <Role> roles = Seed.GetRoles(addedRights); repository.AddRange(roles); repository.Save(); } IQueryable <User> existingUsers = repository.GetAll <User>(); if (existingUsers.IsEmpty()) { IList <Role> addedRoles = repository.GetAll <Role>().ToList(); IList <User> users = Seed.GetUsers(addedRoles); repository.AddRange(users); repository.Save(); } IQueryable <PaymentChannel> existingPaymentChannels = repository.GetAll <PaymentChannel>(); if (existingPaymentChannels.IsEmpty()) { IList <PaymentChannel> paymentChannels = Seed.GetPaymentChannels(); repository.AddRange(paymentChannels); repository.Save(); } IQueryable <ProductType> existingProductTypes = repository.GetAll <ProductType>(); if (existingProductTypes.IsEmpty()) { IList <ProductType> productTypes = Seed.GetProductTypes(); repository.AddRange(productTypes); repository.Save(); } }