[severos]

I have a .net core 2 web application (MVC) with entity framework and using the IdentityUser.
I want to check using the injected UserManager if the current user DB is empty or not, if it's empty then I need to initialize it with a default user.
What's the proper place to initialize? and how would I implement it properly??

[iNCEPTiON_V]

We need more Infotmation than just "DB". Are you using EntityFramework.Core.SQlite ? with Repositorys?
Tell us your complete Environment.

[severos]

I'm using EF and connecting to LocalSQL.
What I currently do is write an Init controller that will initialize DB values for me, after that I delete it from project. However I find it pretty ugly way of doing it, so I'm looking for a better way of initializing DB.

[theogg]

I'm using EF and connecting to LocalSQL.
What I currently do is write an Init controller that will initialize DB values for me, after that I delete it from project. However I find it pretty ugly way of doing it, so I'm looking for a better way of initializing DB.

Can you post code, please?

[severos]

Can you post code, please?

Can't see why you'd need the code... anyway here it is:

PHP Code


<?php 
void InitDb(UserManager<ApplicationUser> userManager, RoleManager<ApplicationRole> roleManager)
        {
            var admin = new ApplicationUser
            {
                UserName = "Admin",
                EmailConfirmed = true,
                PhoneNumberConfirmed = true,
                Id = 0
            };
            userManager.CreateAsync(admin, "AdminDef@1t").Wait();
            var adminRole = new ApplicationRole{Description = "Super Admin",Name = "Super Admin"};
            roleManager.CreateAsync(adminRole).Wait();
            var adminPanelRole = new ApplicationRole {Description = "Access to Admin Panel", Name = "Admin Panel"};
            roleManager.CreateAsync(adminPanelRole).Wait();
            var createContent =
                new ApplicationRole {Description = "Able to submit news/jobs", Name = "Content Creator"};
            roleManager.CreateAsync(createContent).Wait();
            userManager.AddToRolesAsync(admin, new string[] {"Super Admin", "Admin Panel", "Content Creator"}).Wait();
        } 


[Ninja]

Why would you need a default user if the database is empty?

[severos]

Why would you need a default user if the database is empty?

So the admin can start working?
Normally I would enter admin login manually, however there are some concurrency stamps and other fields that I don't like to manually enter, so I wanted an automatic way for doing it.

[Ninja]

So the admin can start working?
Normally I would enter admin login manually, however there are some concurrency stamps and other fields that I don't like to manually enter, so I wanted an automatic way for doing it.

This could be solved using a stored procedure. I dont know how that works with EF as I have little experience with it, though.