Articles → ASP .NET CORE → How To Create The Database Tables For The Identity Server In The Asp.Net Core

How To Create The Database Tables For The Identity Server In The Asp.Net Core

In this article, we will create the database table for the identity server using the code-first approach.

What Is An Identityserver?

IdentityServer4 is an OpenID Connect and OAuth 2.0 framework for ASP.NET Core.

Steps

For creating the table, we will work on the following steps: -

Create an ASP.NET core empty project
Add a connection string in appsettings.json
Add NuGet packages
Add a new class inherited from IdentityDbContext class
Add code to Program.cs
Write commands in the Package Manager Console

Create An ASP.NET Core Empty Project

First, create a new asp.net core empty project.

Picture showing selecting the asp.net core empty project as project template

Click to Enlarge

Add A Connection String In Appsettings.Json

The second step is to add a connection string in the appsettings.json file.

Picture showing adding the connection string in appsettings.json file

Click to Enlarge

Please note that the database IdentityServerDemo is not yet created. We will create it using the code-first approach.

Add Nuget Packages

Add the following NuGet packages to the project.

IdentityServer4
IdentityServer4.AspNetIdentity
IdentityServer4.EntityFramework
Microsoft.AspNetCore.Identity.EntityFrameworkCore
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Design
Microsoft.EntityFrameworkCore.SqlServer

Picture showing the list of packages installed in the project

Click to Enlarge

Please note that the version of the packages is the same.

Add A New Class Inherited From Identitydbcontext Class

Create a new folder and inside the folder, add a class.

Picture showing the AspNetIdentityDbContext file created inside the Data folder

Click to Enlarge

Inside the class, write the following code: -

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;

namespace IdentityServerTablesDemo.Data
{
    public class AspNetIdentityDbContext : IdentityDbContext
    {
        public AspNetIdentityDbContext(DbContextOptions<AspNetIdentityDbContext> options) : base(options)
        {

        }
    }

}

Add Code To Program.Cs

Add the following code in Program.cs.

using IdentityServerTablesDemo.Data;
using Microsoft.EntityFrameworkCore;
using System.Reflection;
using Microsoft.AspNetCore.Identity;

var builder = WebApplication.CreateBuilder(args);

// Code added for IdentityServer tables
var assembly = typeof(Program).Assembly.GetName().Name;
var defaultconnectionString = builder.Configuration["DefaultConnection"];

builder.Services.AddDbContext<AspNetIdentityDbContext>(options =>
options.UseSqlServer(defaultconnectionString, b =>
b.MigrationsAssembly(assembly)));

builder.Services.AddIdentity<IdentityUser, IdentityRole>()
    .AddEntityFrameworkStores<AspNetIdentityDbContext>();

builder.Services.AddIdentityServer()
    .AddAspNetIdentity<IdentityUser>()
        .AddConfigurationStore(options =>
        {
            options.ConfigureDbContext = b => b.UseSqlServer(defaultconnectionString, opt => opt.MigrationsAssembly(assembly));
        })
        .AddOperationalStore(options =>
        {
            options.ConfigureDbContext = b => b.UseSqlServer(defaultconnectionString, opt => opt.MigrationsAssembly(assembly));
        })
        .AddDeveloperSigningCredential();

// Code added for IdentityServer tables ends here


var app = builder.Build();

// Code added for IdentityServer tables
app.UseIdentityServer();
// Code added for IdentityServer tables ends here

app.Run();

Write Commands In The Package Manager Console

Before writing any command in the Package Manager Console, build the project to ensure that there is no compile time error(s).

Open Package Manager Console and write the following commands: -

Add-migration InitialIdentityServerMigration -c PersistedGrantDbContext

update-database -Context PersistedGrantDbContext

Add-migration AnotherMigration -c ConfigurationDbContext

update-database -Context ConfigurationDbContext

Add-migration AspNetIdentityDbContextMigration -c AspNetIdentityDbContext

update-database -Context AspNetIdentityDbContext

In the above commands, please note that: -

The commands should be executed one by one
InitialIdentityServerMigration, AnotherMigration and AspNetIdentityDbContextMigration are the migration names. You can give any name here

Output

The following tables are created.

Picture showing the list of identityserver tables created in sql server

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Monday, November 21, 2022

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**