ef框架连接mysql

dotnet add package Microsoft.EntityFrameworkCore
dotnet add package MySql.EntityFrameworkCore

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=mydatabase;Uid=myuser;Pwd=mypassword;"
  }
}

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

using Microsoft.EntityFrameworkCore;

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
        : base(options)
    {
    }

    public DbSet<Product> Products { get; set; }
}

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<ApplicationDbContext>(options =>
        options.UseMySQL(Configuration.GetConnectionString("DefaultConnection")));
}

using System;
using System.Linq;

public class Program
{
    public static void Main(string[] args)
    {
        using (var context = new ApplicationDbContext(Configuration.GetConnectionString("DefaultConnection")))
        {
            // 添加新产品
            var newProduct = new Product { Name = "Laptop", Price = 1000 };
            context.Products.Add(newProduct);
            context.SaveChanges();

            // 查询所有产品
            var products = context.Products.ToList();
            foreach (var product in products)
            {
                Console.WriteLine($"Product ID: {product.Id}, Name: {product.Name}, Price: {product.Price}");
            }
        }
    }
}