1. Open Visual Studio.

2. Click Create a new project.

3. In the Create a new project dialog, select the project template:

3.1. Filter out the list of project templates by configuring the following parameters:

• The C# project language.

• The Windows project platform.

• The Web project type.

3.2. Select the ASP.NET Core Web App (Model-View-Controller) project template.

Tip:
To find the template, enter its name in the search box, then select the matching result.

4. Click Next.

5. In the Configure your new project dialog, configure the project settings:

• Project name – Enter the project name. The default project name is WebApplication followed by a sequential number, such as WebApplication1, WebApplication2, WebApplication3, etc.

• Location – Click the ellipsis (...) and specify the path to save the project. The default path is:

C:\Users\%USERPROFILE%\source\repos

• Solution name – Enter a folder name where you want to store one or more projects. The default solution name is the same as the project name.

Note If you don't want to create a solution folder, select Place solution and project in the same directory.

6. Click Next.

7. In the Additional information dialog, configure additional project settings:

• Framework – Select .NET 10.0.

• Authentication type – Select Individual Accounts.

• Optional: Configure additional options such as container support, top-level statements, and orchestration settings according to your project requirements.

8. Click Create.

The project opens in Visual Studio.

9. In Package Manager Console, execute the following command:

install-package Devart.Data.MySql.EFCore

10. In the appsettings.json project file, replace the default connection parameters with your MySQL connection settings.

"ConnectionStrings": {
    "DefaultConnection": "User Id=root;Host=localhost;Database=Test;"
  },

Tip:
To add your license key to the connection string, use the LicenseKey parameter.

11. In the Program.cs project file, locate the following line:

options.UseSqlServer(connectionString));

and replace it with:

options.UseMySql(connectionString));

12. In Solution Explorer, navigate to the Data > Migrations folder, then clear its contents.

13. In Package Manager Console, execute the following commands one by one:

add-migration CreateIdentitySchema -OutputDir Data\Migrations

update-database

1. Select C# from the left-hand side of the list, then move to the middle section to choose Windows, and finally select Web on the right. Next, select ASP.NET Core Web Application, proceed by clicking Next, and then select Create.
   
   
   

2. In the next dialog, select the Web Application (Model-View-Controller) template.
   
   
   Visual Studio 2019
   

3. To proceed, click Change under Authentication.

4. Then select Individual User Accounts as the authentication method and click OK.

5. Execute the following command in the Package Manager Console:

   install-package Devart.Data.MySql.EFCore

6. In the appsettings.json file of your project, replace the default connection string with your MySQL one. For example:

   "ConnectionStrings": { "DefaultConnection": "User Id=root;Host=localhost;Database=Test;" },

   If you purchased dotConnect for MySQL, add your license key to the connection string as the License Key connection string parameter.

7. In the Startup.cs file of the application, replace

   options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

   with

   options.UseMySql(Configuration.GetConnectionString("DefaultConnection")));

8. In the Solution Explorer, open the Data\Migrations folder and delete all its content.

9. Execute the following command in the Package Manager Console:

   add-migration CreateIdentitySchema -OutputDir Data\Migrations

10. Execute the following command in the Package Manager Console:

    update-database

1. In the New Project dialog, expand Visual C# on the left, click Web, and select ASP.NET Core Web Application (.NET Core). Name your project, for example, "AspNetCore_Identity_Application", and click OK.
   
   
   

2. In the next dialog, select the Web Application (Model-View-Controller) template.
   
   
   Visual Studio 2017
   

3. To proceed, click Change Authentication.

4. Then select Individual User Accounts as the authentication method and click OK.

5. Execute the following command in the Package Manager Console:

   install-package Devart.Data.MySql.EFCore

6. In the appsettings.json file of your project, replace the default connection string with your MySQL one. For example:

   "ConnectionStrings": { "DefaultConnection": "User Id=root;Host=localhost;Database=Test;" },

   If you purchased dotConnect for MySQL, add your license key to the connection string as the License Key connection string parameter.

7. In the Startup.cs file of the application, replace

   options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

   with

   options.UseMySql(Configuration.GetConnectionString("DefaultConnection")));

8. In the Solution Explorer, open the Data\Migrations folder and delete all its content.

9. Execute the following command in the Package Manager Console:

   add-migration CreateIdentitySchema -OutputDir Data\Migrations

10. Execute the following command in the Package Manager Console:

    update-database