mysql怎么使用ef

Install-Package MySql.Data.EntityFramework -Version 8.0.27

public class Student
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

public class SchoolContext : DbContext
{
    public DbSet<Student> Students { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseMySQL("server=localhost;port=3306;database=school;uid=root;password=yourpassword;");
    }
}

class Program
{
    static void Main(string[] args)
    {
        using (SchoolContext context = new SchoolContext())
        {
            // 添加学生
            var student = new Student { Name = "Alice", Age = 20 };
            context.Students.Add(student);
            context.SaveChanges();

            // 查询学生
            var students = context.Students.ToList();
            foreach (var s in students)
            {
                Console.WriteLine($"ID: {s.Id}, Name: {s.Name}, Age: {s.Age}");
            }
        }
    }
}

Add-Migration InitialCreate
Update-Database