asp.net core seed data with startup

Marius Vasile

5y4.1k.NET

I am trying to seed data at startup in preparation for publishing. I want to have the web admin seeded at startup. What I did is

a class

using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using RoSafety.Data;
using RoSafety.Models;
using System.Linq;
namespace RoSafety
{
public class RoSafetyDbStartup
{
private readonly ApplicationDbContext _context;
public RoSafetyDbStartup(ApplicationDbContext context)
{
_context = context;
}
public async void SeedAdminUser()
{
var user = new UserDataClass
{
UserName = "[email protected]",
NormalizedUserName = "[email protected]",
Email = "[email protected]",
OrgID = "RS-001",
NormalizedEmail = "[email protected]",
EmailConfirmed = true,
LockoutEnabled = true
};
var roleStore = new RoleStore(_context);
if(!_context.Roles.Any(r => r.Name == "AdminNew"))
{
await roleStore.CreateAsync(new UserRoleClass { Name = "AdminNew", NormalizedName = "ADMINNEW" });
}
if(!_context.Users.Any(u => u.UserName == user.UserName))
{
var password = new PasswordHasher();
var hashed = password.HashPassword(user, "vsdrg4gherrhb4re54#RFw");
user.PasswordHash = hashed;
var userStore = new UserStore(_context);
await userStore.CreateAsync(user);
await userStore.AddToRoleAsync(user, "AdminNew");
}
await _context.SaveChangesAsync();
}
}
}

and in statup

public void Configure(IApplicationBuilder app, IWebHostEnvironment env, RoSafetyDbStartup dbInit)
{
.................................other data........................
dbInit.SeedAdminUser();
}

but no data is updated in AspNetUsers or AspNetRoles on database-update

Oh, and my Identity is

public class UserDataClass : IdentityUser
{
......some data.....
}
public class UserRoleClass : IdentityRole
{
public virtual ICollection AppUserRoles { get; set; }
}
public class AppIdentityRole : IdentityUserRole<string>
{
public virtual UserDataClass User { get; set; }
public virtual UserRoleClass Role { get; set; }
}

What am I doing wrong?

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kiran Mohanty5y ago
Accepted answer
I am assuming ApplicationDbContext class is inheriting from IdentityDbContext. if so , please call your seeding method inside OnModelCreating() as below.
public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions options)
:base(options)
        {

        }

        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);
            //Data you wish to seed
            builder.Entity().HasData(
                new User() { UserName = "Superadmin", PasswordHash = "test123" },
                new User() { UserName = "Admin", PasswordHash = "admin123" }
                );
        }

    }
+4
Marius Vasile5y ago
I end up using solution here

https://frankofoedu.medium.com/how-to-seed-identity-role-with-associated-user-in-asp-net-core-ef-core-e40ecd643d0f

so your first approach is the one I followed
+4
Marius Vasile5y ago
The entire solution? Like on github? I really don't want to do that, but I can give you access through teamviewer if you prefer this way
+3
Kiran Mohanty5y ago
based on your approach, dbInit.SeedAdminUser() line code should trigger the seed.

Talking about update-database command in server, that we can do in several ways.
System.Data.Entity.Database.SetInitializer(new MigrateDatabaseToLatestVersion());
please take a look at

https://stackoverflow.com/questions/17020393/asp-net-mvc-4-migrations-how-to-run-update-database-on-a-production-server

If you don't mind, can please share your solution ? its tough to guess whats wrong without seeing complete code.
+3
Marius Vasile5y ago
I was looking at the example in
https://stackoverflow.com/questions/34343599/how-to-seed-users-and-roles-with-code-first-migration-using-identity-asp-net-cor
I based my approach on that but is not working and I don't know what is wrong. The Identity table is there with data but not updated with seed data. Anyway, what trigger the seed? update-database command is enough? how do i trigger the update when I upload the files on the server? I don't know that either
+3
Kiran Mohanty5y ago
Here is a link for you based on your approach. I see you have missed defining and calling

AssignRoles() method. Please take a look at it.

https://stackoverflow.com/questions/34343599/how-to-seed-users-and-roles-with-code-first-migration-using-identity-asp-net-cor
+3
Kiran Mohanty5y ago
can you see Identity table in your database ? Is your application running without any exception ?
+3
Marius Vasile5y ago
ApplicationDbContext is inherited from IdentityDbContext, yes
public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions options)
            : base(options)
        {
        }
but I have to create the role also and assign it to the user. I can't do that from OnModelCreating, it has to be from startup
+3
Marius Vasile5y ago
I have this
services.AddIdentity(options => options.SignIn.RequireConfirmedAccount = true)
                .AddDefaultUI()
                .AddRoles()
                .AddDefaultTokenProviders()
                .AddEntityFrameworkStores();
In the app, I can register new users, create and assign roles but I need the overall admin for the application, especially when into production
+2
Kiran Mohanty5y ago
Hi,
have you defined your database class that is inherited from IdentityDbContext ? and have you registered it inside ConfigureServices in Startup.Cs?
+2