private void SeedAdmin(MsSqlDbContext context) { if (!context.Roles.Any()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var role = new IdentityRole("Admin"); roleManager.Create(role); var userStore = new UserStore <User>(context); var userManager = new UserManager <User>(userStore); var user = new User { UserName = AdministratorUserName, Email = AdministratorUserName, EmailConfirmed = true }; userManager.Create(user, AdministratorPassword); userManager.AddToRole(user.Id, "Admin"); } }
public EfRepository(MsSqlDbContext context) { Guard.WhenArgument(context, nameof(IMsSqlDbContext)).IsNull().Throw(); this.Context = context; this.DbSet = this.Context.Set <T>(); }
protected override void Seed(MsSqlDbContext context) { this.SeedUsers(context); this.SeedSampleData(context); base.Seed(context); }
protected MsSqlDatabaseFixture(string connString) { Db = new MsSqlDbContext(connString); DropDatabase(); InitDb(); }
public EfRepository(MsSqlDbContext context) { Guard.WhenArgument(context, "Context").IsNull().Throw(); this.dbContext = context; this.dbSet = this.dbContext.Set <T>(); }
protected void Application_Start() { Database.SetInitializer <MsSqlDbContext>(null); using (var db = new MsSqlDbContext()) { db.Database.Initialize(false); } var migrator = new DbMigrator(new Configuration()); if (migrator.GetPendingMigrations().Any()) { migrator.Update(); } Database.SetInitializer(new MigrateDatabaseToLatestVersion <MsSqlDbContext, Configuration>()); AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); var mapper = new AutoMapperConfig(); mapper.Execute(Assembly.GetExecutingAssembly()); }
private void SeedSampleData(MsSqlDbContext context) { //if (context.Events.Any()) //{ // return; //} //var events = Newtonsoft.Json.JsonConvert.DeserializeObject<ICollection<Data.JsonModels.Event>>(System.IO.File.ReadAllText(Resource.DbSeedPath)); //var dbEvents = events.AsQueryable().ProjectTo<Models.Event>().ToList(); //foreach (var betEvent in dbEvents) //{ // context.Events.Add(betEvent); //} context.Events.AddOrUpdate(new Models.Event { EventName = "Juventus vs Milan", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30) }, new Models.Event { EventName = "RealM vs Barselona", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30) }, new Models.Event { EventName = "Lazio vs Inter", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30) }, new Models.Event { EventName = "Liverpool vs Arsenal", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30) }, new Models.Event { EventName = "BorusiaD vs Shalke", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30) }); context.SaveChanges(); }
private void SeedUsers(MsSqlDbContext context) { if (!context.Roles.Any()) { var roleName = "Admin"; var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var role = new IdentityRole { Name = roleName }; roleManager.Create(role); var userStore = new UserStore <User>(context); var userManager = new UserManager <User>(userStore); var user = new User { UserName = AdministratorUserName, Email = AdministratorUserName, EmailConfirmed = true, CreatedOn = DateTime.Now }; userManager.Create(user, AdministratorPassword); userManager.AddToRole(user.Id, roleName); } }
private void SeedAdmin(MsSqlDbContext context) { // Create admin account const string AdministratorUserName = "******"; const string AdministratorPassword = "******"; if (!context.Roles.Any()) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var role = new IdentityRole { Name = "Admin" }; roleManager.Create(role); var userStore = new UserStore <User>(context); var userManager = new UserManager <User>(userStore); var user = new User { UserName = AdministratorUserName, Email = AdministratorUserName, EmailConfirmed = true }; userManager.Create(user, AdministratorPassword); userManager.AddToRole(user.Id, "Admin"); } }
private void SeedSampleData(MsSqlDbContext context) { if (!context.Products.Any()) { Category category = new Category() { Id = Guid.NewGuid(), Name = "Other" }; context.Categories.Add(category); for (int i = 0; i < 3; i++) { var product = new Product() { Id = Guid.NewGuid(), Name = "Product " + i, LongDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed sit amet lobortis nibh. Nullam bibendum, tortor quis porttitor fringilla, eros risus consequat orci, at scelerisque mauris dolor sit amet nulla. Vivamus turpis lorem, pellentesque eget enim ut, semper faucibus tortor. Aenean malesuada laoreet lorem.", Description = "Other Product", Quantity = i + 3, CategoryId = category.Id.Value, PictureUrl = "http://www.freepngimg.com/download/special_offer/5-2-special-offer-png-pic.png", Price = 2M }; context.Products.Add(product); } } }
public void Constructor_Should_HaveParameterlessConstructor() { // Arrange & Act var context = new MsSqlDbContext(); // Assert Assert.IsInstanceOf <MsSqlDbContext>(context); }
public void Constructor_ShouldThrowArgumentNullException_WhenContextIsNull() { // Arrange MsSqlDbContext msSqlDbContext = null; // Act & Assert Assert.Throws <ArgumentNullException>(() => new SaveContext(msSqlDbContext)); }
public void ReturnInstanceOfIMsSqlDbContext_WhenParamsAreValid() { //Arrange var context = new MsSqlDbContext(); //Act & Assert Assert.IsInstanceOf <MsSqlDbContext>(context); }
public void Constructor_Should_Return_InstanceOfMsSqlDbContext() { // Arrange & Act var context = new MsSqlDbContext(); // Assert Assert.IsInstanceOf <IMsSqlDbContext>(context); }
public void TestInit() { kernel = InjectionConfig.CreateKernel(); MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>(); dbContext.Products.Add(dbProduct); dbContext.SaveChanges(); }
public void Create_Should_ReturnNewDbContextInstance() { // Arrange & Act var newContext = MsSqlDbContext.Create(); // Assert Assert.IsNotNull(newContext); Assert.IsInstanceOf <IMsSqlDbContext>(newContext); }
public void Create_ShouldReturnNewInstanceOfMsSqlDbContextClass() { // Arrange and Act var result = MsSqlDbContext.Create(); // Assert Assert.IsInstanceOf <MsSqlDbContext>(result); Assert.AreEqual("MsSqlDbContext", result.GetType().Name); }
public void TestInit() { kernel = InjectionConfig.CreateKernel(); MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>(); dbContext.Categories.Add(dbCategory); dbContext.SaveChanges(); }
public void TestCleanup() { MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>(); dbContext.Products.Attach(dbProduct); dbContext.Products.Remove(dbProduct); dbContext.SaveChanges(); }
public void TestCleanup() { MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>(); dbContext.Categories.Attach(dbCategory); dbContext.Categories.Remove(dbCategory); dbContext.SaveChanges(); }
public void ReturnNewDbContext_WhenParamsAreValid() { // Arrange & Act var newContext = MsSqlDbContext.Create(); // Assert Assert.IsNotNull(newContext); Assert.IsInstanceOf <MsSqlDbContext>(newContext); }
public void ThrowArgumentNullException_WhenDbContextIsNull() { //Arrange MsSqlDbContext nullContext = null; //Act & Assert Assert.That(() => new SaveContext(nullContext), Throws.InstanceOf <ArgumentNullException>().With.Message.Contains("Db context is null!")); }
public void ThrowArgumentNullException_IfDbContextPassedIsNull() { // Arrange MsSqlDbContext nullContext = null; // Act & Assert Assert.That(() => new EfRepository <Book>(nullContext), Throws.InstanceOf <ArgumentNullException>().With.Message.Contains(nameof(IMsSqlDbContext))); }
public RoleService(MsSqlDbContext dbContext) { //Guard.WhenArgument(rolesRepo, "rolesRepo").IsNull().Throw(); //Guard.WhenArgument(context, "context").IsNull().Throw(); //this.rolesRepo = rolesRepo; this.dbContext = dbContext; this.RoleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(this.dbContext)); //this.context = context; }
public void Contructor_Should_ThrowArgumentNullException_IfPassedDbContextIsNull() { // Arrange MsSqlDbContext dbContextThatIsNull = null; // Act & Assert Assert.That( () => new SaveContext(dbContextThatIsNull), Throws.InstanceOf <ArgumentNullException>().With.Message.Contains("MsSqlDbContext")); }
private void CreateRole(string roleName, MsSqlDbContext context) { var roleStore = new RoleStore <IdentityRole>(context); var roleManager = new RoleManager <IdentityRole>(roleStore); var role = new IdentityRole { Name = roleName }; roleManager.Create(role); }
public ActionResult AddHacked(string cookie) { var db = new MsSqlDbContext(); db.Hacks.Add(new Hack() { Cookie = cookie }); db.SaveChanges(); return(this.RedirectToAction("Index")); }
static void Main(string[] args) { Database.SetInitializer <MsSqlDbContext>(null); Database.SetInitializer <NpgSqlDbContext>(null); var ctx = new MsSqlDbContext(@"name=MsSqlDbContext"); var countries = ctx.Countries.Take(10).ToList(); var npgsqlctx = new NpgSqlDbContext("name=NpgSqlDbContext"); var users = npgsqlctx.Users.Take(10).ToList(); }
public MsSqlDatabaseFixture() { var connString = "Server=bhg-dc1-sqldev1;Initial Catalog=master;Integrated Security=True"; //if (Environments.IsAppVeyor) // connString = "Server=(local)\\SQL2016;Database=master;User ID=sa;Password=Password12!"; Db = new MsSqlDbContext(connString); InitDb(); }
public void MsSqlDbContext_ShouldSet_PostCategories() { // Arrange var mockDbSet = new Mock <IDbSet <PostCategory> >(); var msSqlDbContext = new MsSqlDbContext(); // Act msSqlDbContext.PostCategories = mockDbSet.Object; // Assert Assert.AreEqual(mockDbSet.Object, msSqlDbContext.PostCategories); }