protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); // any guid const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575"; // any guid, but nothing is against to use the same one const string ROLE_ID = ADMIN_ID; modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole { Id = ROLE_ID, Name = "Administrador", NormalizedName = "ADMINISTRADOR" }); var hasher = new PasswordHasher <Usuario>(); modelBuilder.Entity <Usuario>().HasData(new Usuario { Id = ADMIN_ID, Nome = "Admin", UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hasher.HashPassword(null, "12345678"), SecurityStamp = hasher.GetHashCode().ToString() }); modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string> { RoleId = ROLE_ID, UserId = ADMIN_ID }); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity <Cidade>().HasData(new Cidade { Id = 1, Nome = "Barra Bonita", Estado = "SP" }, new Cidade { Id = 2, Nome = "Igaraçu do Tietê", Estado = "SP" }, new Cidade { Id = 3, Nome = "Bauru", Estado = "SP" }, new Cidade { Id = 4, Nome = "Macatuba", Estado = "SP" }, new Cidade { Id = 5, Nome = "Pederneiras", Estado = "SP" }, new Cidade { Id = 6, Nome = "Lençois Paulista", Estado = "SP" }); modelBuilder.Entity <TipoObra>().HasData(new TipoObra { Id = 1, Nome = "Fotografia" }, new TipoObra { Id = 2, Nome = "Artes Plásticas" }, new TipoObra { Id = 3, Nome = "Escultura" }, new TipoObra { Id = 4, Nome = "Pintura" }, new TipoObra { Id = 5, Nome = "Modelagem 3D" }); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); // any guid const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575"; // any guid, but nothing is against to use the same one const string ROLE_ID = ADMIN_ID; modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole { Id = ROLE_ID, Name = "Administrador", NormalizedName = "ADMINISTRADOR" }, new IdentityRole { Id = Guid.NewGuid().ToString(), Name = "Artista", NormalizedName = "ARTISTA" }); var hasher = new PasswordHasher <Usuario>(); modelBuilder.Entity <Usuario>().HasData(new Usuario { Id = ADMIN_ID, Nome = "Admin", UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hasher.HashPassword(null, "123456"), SecurityStamp = hasher.GetHashCode().ToString() }); modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string> { RoleId = ROLE_ID, UserId = ADMIN_ID }); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); // any guid const string ADMIN_ID = "a18be9c0-aa65-4af8-bd17-00bd9344e575"; // any guid, but nothing is against to use the same one const string ROLE_ID = ADMIN_ID; modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole { Id = ROLE_ID, Name = "Administrador", NormalizedName = "ADMINISTRADOR" }, new IdentityRole { Id = Guid.NewGuid().ToString(), Name = "Visitante", NormalizedName = "VISITANTE" }); var hasher = new PasswordHasher <Usuario>(); modelBuilder.Entity <Usuario>().HasData(new Usuario { Id = ADMIN_ID, Nome = "Admin", UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hasher.HashPassword(null, "123456"), SecurityStamp = hasher.GetHashCode().ToString(), DataNascimento = Convert.ToDateTime("08/04/2002"), Apelido = "Admin" }); modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string> { RoleId = ROLE_ID, UserId = ADMIN_ID }); }
protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); //para que definir um tamanho maximo de caracter, para que o banco aguente... //controla as informações do usuários, esses campos vem do Identity.EntityFrameworkCore... modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85)); modelBuilder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85)); //identityRole seria o perfil modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85)); modelBuilder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); //muitos pra muitos modelBuilder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); modelBuilder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); modelBuilder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); //somente se tiver o migration funcionando... //any guid(Um alfa numerico) //chave do usuario const string ADMIN_ID = "al8be9c0-aa65-4af8-bd17-00bd9344e575"; //any guid, but nothing is against to use the same one const string ROLE_ID = ADMIN_ID; //startando os dados do perfil do admin modelBuilder.Entity <IdentityRole>().HasData(new IdentityRole { Id = ROLE_ID, Name = "Administrador", NormalizedName = "ADMINISTRADOR" }, /*Novo usuario*/ new IdentityRole { Id = Guid.NewGuid().ToString(), Name = "Artista", NormalizedName = "ARTISTA" }); //startando um usuario se não não vai ter como logar //hasher possui os componentes para criar criptografia var hasher = new PasswordHasher <Usuario>(); modelBuilder.Entity <Usuario>().HasData(new Usuario { Id = ADMIN_ID, Nome = "Admin", UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hasher.HashPassword(null, "123456"), SecurityStamp = hasher.GetHashCode().ToString() }); modelBuilder.Entity <IdentityUserRole <string> >().HasData(new IdentityUserRole <string> { RoleId = ROLE_ID, UserId = ADMIN_ID }); modelBuilder.Entity <Cidade>().HasData(new Cidade { Id = 1, Nome = "Barra Bonita", Estado = "SP" }, new Cidade { Id = 2, Nome = "Igaraçu do Tietê", Estado = "SP" }, new Cidade { Id = 3, Nome = "Bauru", Estado = "SP" }, new Cidade { Id = 4, Nome = "Macatuba", Estado = "SP" }, new Cidade { Id = 5, Nome = "Pederneiras", Estado = "SP" }, new Cidade { Id = 6, Nome = "Lençois Paulista", Estado = "SP" }); modelBuilder.Entity <TipoObra>().HasData(new TipoObra { Id = 1, Nome = "Fotografia" }, new TipoObra { Id = 2, Nome = "Artes Plásticas" }, new TipoObra { Id = 3, Nome = "Escultura" }, new TipoObra { Id = 4, Nome = "Pintura" }, new TipoObra { Id = 5, Nome = "Modelagem 3D" }); }
protected override void OnModelCreating(ModelBuilder builder) { base.OnModelCreating(builder); builder.Entity <Usuario>(entity => entity.Property(m => m.Id).HasMaxLength(85)); builder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85)); builder.Entity <Usuario>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85)); builder.Entity <IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85)); builder.Entity <IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85)); builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85)); builder.Entity <IdentityUserLogin <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); builder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); builder.Entity <IdentityUserRole <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85)); builder.Entity <IdentityUserToken <string> >(entity => entity.Property(m => m.Name).HasMaxLength(85)); builder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); builder.Entity <IdentityUserClaim <string> >(entity => entity.Property(m => m.UserId).HasMaxLength(85)); builder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.Id).HasMaxLength(85)); builder.Entity <IdentityRoleClaim <string> >(entity => entity.Property(m => m.RoleId).HasMaxLength(85)); // IDS dos perfis string ROLE_ADMIN_ID = Guid.NewGuid().ToString(); string ROLE_CLIENTE_ID = Guid.NewGuid().ToString(); // IDS dos usuarios string ADMIN_ID = Guid.NewGuid().ToString(); string CLIENTE_ID = Guid.NewGuid().ToString(); // Permiti cadastrar um perfil builder.Entity <IdentityRole>().HasData( new IdentityRole { Id = ROLE_ADMIN_ID, // Chave primaria Name = "Administrador", NormalizedName = "ADMINISTRADOR" // Regra - fica tudo em maiusculo }, new IdentityRole { Id = ROLE_CLIENTE_ID, // Chave primaria Name = "Cliente", NormalizedName = "CLIENTE" // Regra - fica tudo em maiusculo } ); // Criptografia da senha var hash1 = new PasswordHasher <Usuario>(); var hash2 = new PasswordHasher <Usuario>(); builder.Entity <Usuario>().HasData( new Usuario { Id = ADMIN_ID, Nome = "Admin", Apelido = "Admin", DataNascimento = DateTime.Now, // Retorna data e hora na hora criada UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hash1.HashPassword(null, "ateliemoonchild123456789"), // Nulo e senha que vai ser criptografada SecurityStamp = hash1.GetHashCode().ToString() // Necessario para discriptografa }, new Usuario { Id = CLIENTE_ID, Nome = "Alexandre Tavano Cardoso", Apelido = "Tavano", DataNascimento = Convert.ToDateTime("05/08/2002"), UserName = "******", NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**", EmailConfirmed = true, PasswordHash = hash2.HashPassword(null, "UserProgramador123"), // Nulo e senha que vai ser criptografada SecurityStamp = hash2.GetHashCode().ToString() // Necessario para discriptografa } ); // Determina qual user é de qual categoria builder.Entity <IdentityUserRole <string> >().HasData( new IdentityUserRole <string> { RoleId = ROLE_ADMIN_ID, UserId = ADMIN_ID }, new IdentityUserRole <string> { RoleId = ROLE_CLIENTE_ID, UserId = CLIENTE_ID } ); }