public override void InitializeDatabase(IdentityDbContext context)
        {
            context.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction
                                               , string.Format("ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE", context.Database.Connection.Database));

            context.Set <CompSuppManager.Supplier>().AddOrUpdate(x => x.Id, new CompSuppManager.Supplier {
                Id = 0
            });


            base.InitializeDatabase(context);
        }
        protected override void Seed(IdentityDbContext context)
        {
            var userManager = new UserManager <ApplicationUser>(new
                                                                UserStore <ApplicationUser>(context));
            var roleManager = new RoleManager <ApplicationRole>(new
                                                                RoleStore <ApplicationRole>(context));
            const string name     = "Admin";
            const string password = "******";

            #region addAllRoles
            //if (!roleManager.RoleExists(name))
            //{
            //    var roleresult = roleManager.Create(new ApplicationRole(name));
            //}
            //if (!roleManager.RoleExists("Clerk"))
            //{
            //    roleManager.Create(new ApplicationRole("Clerk"));
            //}

            //if (!roleManager.RoleExists("Customer"))
            //{
            //    roleManager.Create(new ApplicationRole("Customer"));
            //}
            //if (!roleManager.RoleExists("Merchandise"))
            //{
            //     roleManager.Create(new ApplicationRole("Merchandise"));
            //}
            //if (!roleManager.RoleExists("Manager"))
            //{
            //    roleManager.Create(new ApplicationRole("Manager"));
            //}
            #endregion
            var user = new ApplicationUser();
            user.UserName = name;
            var adminresult = userManager.Create(user, password);

            if (adminresult.Succeeded)
            {
                if (!roleManager.RoleExists("Admin"))
                {
                    var role = new ApplicationRole();
                    role.Name = "Admin";
                    roleManager.Create(role);
                }
                var result = userManager.AddToRole(user.Id, name);
            }
            base.Seed(context);
        }