I am developing one application using asp dot net core 2 using MySql database.Please help me How can i use Asp Net Identity in MySqlDatabase.
相关问题
- Carriage Return (ASCII chr 13) is missing from tex
- How to store image outside of the website's ro
- 'System.Threading.ThreadAbortException' in
- sqlyog export query result as csv
- NOT DISTINCT query in mySQL
You Can create an Identity Database along with your MySQL Database and use the Identity database for your authorization
This is how I do it.
This should work fine along with your MySQL DB
EDIT: At this point, .Net Core 2.0 doesn't support Identity with MySql, in a near future it may be supported again.
__
You need to plug Entity Framework with MySQL with Pomelo's connection and Identity should work. Check this out -> https://damienbod.com/2016/08/26/asp-net-core-1-0-with-mysql-and-entity-framework-core/
I had to do this for a client. And I did in an application with ASP.NET Core 1.0, but for curiosity I also tried for an application in .NET Core 2.0.
What I did was first install the Entity Framework MySQL package from https://www.nuget.org/packages/Pomelo.EntityFrameworkCore.MySql/ using package manager console.
After that I changed in the startup.cs, in the method ConfigureServices, the option UseSqlServer to UseMySql, like the image below.
In my appsettings.json I have the MySQL connection named IdentityConnection like this:
To create the identity tables I executed the migration command in package manager console: