Connecting MYSQL Database to ASP.NET Project

Install Pomelo.EntityFrameworkCore.MySql from Nuget package manager console

2. Set the connection string in appsettings.json as

    {
      "Logging": {
        "LogLevel": {
          "Default": "Information",
          "Microsoft.AspNetCore": "Warning"
        }
      },
      "AllowedHosts": "*",
      "ConnectionStrings": {
        "dbcs": "Server=localhost; Port=3306; Database=bulky; User=root; Password=;PersistSecurityInfo=True;"
      }
    }
   

3. Change the Program.cs file as required to get Mysql connection string

   
    var builder = WebApplication.CreateBuilder(args);
   
    // Add services to the container.
    builder.Services.AddControllersWithViews();
   
    // Register IConfiguration and read connection string from appsettings.json
    builder.Services.AddSingleton(builder.Configuration);
   
    // Configure DbContext with MySQL
    builder.Services.AddDbContext<ApplicationDbContext>((serviceProvider, options) =>
    {
        options.UseMySql(builder.Configuration.GetConnectionString("dbcs"),
            new MySqlServerVersion(new Version(8, 0, 28))); // Adjust the version according to your MySQL server version
    });
   
    var app = builder.Build();
   

4. Now add-migration and update the database.