IdentityServer4.Templates
IdentityServer4.Templates copied to clipboard
Co-enable SQL Server and SQLite Identity/Autogenerate field annotations
As described in EF Core documentation here : https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/providers#one-migration-set
Note : haven't tested this by creating new items with the templates yet. Just stumbled to this after trying to switch from default SQLite implementation to SQL Server.
Apparently AdminUI's migration SQL scripts with files ConfigurationDb.sql and PersistedGrantDb.sql are out-of-sync with IdentityServer4 with Entity Framework Stores template and generate errors after switching provider to SQL Server (during initial migration phase, before seeding).
Maybe better option would be creating the tables (and insertions) with code-first as the SQL dialect seems to differ quite a bit between SQL Server and SQLite implementations.
Hi! AdminUI community edition is limited to SQLite, so changes to that template would need to be removed from the PR.
Ok - will update PR in a minute
Ok - reset the AdminUI template to origin