Identityserver4.admin: Using SQLite as default database engine

[xmichaelx]

A modest suggestion. By default Admin uses SqlServer which has to be separately installed for anyone who doesn't use Visual Studio daily.

Required changes would be pretty small:

UseSqlServer -> UseSqlite in StartupHelpers.cs and adding SQLite provider package for EntityFramework.Core.

I myself use PostgreSQL (works great), but for demonstration purposes I think SQLite would the best choice. This would also make checking out the Admin so much easier for Linux/MacOS folks.

[skoruba]

It's very good point. It would be nice to extend it to other databases.

I can imagine some configuration that you are able to switch database according specific requirments. :)

Btw: Are you using VS Code or similar editor for running this solution?

[xmichaelx]

No, I'm using VS. But I've used VS Code for other .net core projects before and I could test if that works.

[skoruba]

I'll check the possibilities how to combine more configuration of different databases like PostgreSQL, MySQL, SQLite etc.

[xmichaelx]

I think that you could have it added to your migration documentation (where to change provider and what packages to add). Info on how you can use different providers (sqlserver, postgresql, sqlite) with default sqlite provider.

[xmichaelx]

Added steps for changing to other providers: GH-37