ef用于mysql的驱动

using Microsoft.EntityFrameworkCore;
using System;
using System.Linq;

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

    public class ApplicationDbContext : DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySql("Server=localhost;Database=testdb;Uid=root;Pwd=password;");
        }

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

    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new ApplicationDbContext())
            {
                // 添加新产品
                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($"Id: {product.Id}, Name: {product.Name}, Price: {product.Price}");
                }
            }
        }
    }
}