I am in the process of upgrading an existing website to ASP.NET Core 2.1. The goal is simplification and ease of maintenance. Existing site is using:
- EF and .NET 4.6.2
[Users]table in SQL Server which is related to a lot of other tables in the project.
New site is using
Dapper instead of
SQL statements directly in the MVC Controllers, and generally no more stored procs (inspiration from Nick Craver of SO). I have looked into ASP.NET Core Identity as it seems to have a lot pre-built functionality which help on the maintenance part - like "signup using Facebook, LinkedIn and other providers", "reset your password", "confirm account" and more.
My question is:
How would I go about implementing Identity on the new site and re-using the existing
[Users]-table? It seems I need to add additional tables like
[AspNetRoles] etc by using Identity - which in turn conflicts with the existing model relying on the
UserID CustomerID Email Password Active Created IsDeleted
Hoping for some advice, pointers, examples, articles etc. Google was not my friend unfortunately.