c 使用ef连接mysql

using System;
using System.Data.Entity;

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

public class MyDbContext : DbContext
{
    public DbSet<Product> Products { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Product>().ToTable("Products");
    }
}

class Program
{
    static void Main()
    {
        using (var context = new MyDbContext())
        {
            // 添加新产品
            var newProduct = new Product { Name = "Laptop", Price = 999.99m };
            context.Products.Add(newProduct);
            context.SaveChanges();

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