dotConnect for MySQL Documentation
Using Entity Framework Core Implementation of ASP.NET Core Identity for MySQL

ASP.NET Core Identity is a modern system for user authentication and authorization in ASP.NET Core. You can find more information about ASP.NET Core Identity in the official Microsoft documentation.

dotConnect for MySQL provides support for implementing ASP.NET Core Identity with MySQL databases by utilizing Entity Framework Core in your web applications. With this integration, you can take advantage of ASP.NET Core Identity features such as a unit-testable authentication system, social login support, and OWIN integration. This tutorial demonstrates how to create an Entity Framework implementation of ASP.NET Core Identity.

Prerequisites

In order to create an ASP.NET Core application using dotConnect for MySQL for storing identity information, perform the following steps based on the Visual Studio version:

+ Visual Studio 2019, 2022

+ Visual Studio 2017

Checking Application

Now, we can run our application and check if everything works correctly.

  1. Run the application by pressing CTRL+F5.

    Home page

  2. Switch to the Register tab at the top of the page.

    Registration page

  3. Enter your email and password in the designated fields, then click Register.

  4. The new user is registered and logged in, and the ASP.NET Identity tables are created in the MySQL database.

    User is registered

  5. Optional: Use any Oracle client tool to connect to the database where the user data is stored and verify that the information has been saved correctly.

See Also

Using Entity Framework Implementation of ASP.NET Identity 1 for MySQL  | Using Entity Framework Implementation of ASP.NET Identity 2 for MySQL  | Using ADO.NET Implementation of ASP.NET Identity 1 for MySQL  | Using ADO.NET Implementation of ASP.NET Identity 2 for MySQL