I'm trying to implement a custom identity storage provider that can talk to an existing SQL Server database that has bespoke user and role tables.
I have seen all the documentation I can find on implementing the various interfaces.
Looking first to implement the most essential ones so a user can login from a .NET core web app and the system can issue auth cookie identify the user's roles.
Is there an example project that I can look at that implements this? The User and Role stores look straight forward but I'm struggling with the custom DB Context implementation and how it can talk to my database. Also looking for more info on changes to the Startup class of my .NET Core web app and login page that will talk to my custom Identity provider.