How to create Identity Server DB for SQLite?

Question

I have run dotnet new is4ef to create an Identity Server template.

Next I changed UseSqlServer() -> UseSqlite() in Startup.cs.

The program compiles, but the tables in the DB are not created when it runs.

How to create the suitable tables for the configuration store and operational store?

Answer 1

To create the DB, you need to run the migration:

dotnet tool install --global dotnet-ef
dotnet ef migrations add 'initial' --project src/IdentityServer/IdentityServer.csproj --context PersistedGrantDbContext

Then you update the database by

dotnet ef database update --project src/IdentityServer/IdentityServer.csproj --context ConfigurationDbContext

And then the DBs are created.