ef增删改查 mysql

Install-Package MySql.Data.EntityFramework
Install-Package EntityFramework

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

public class ApplicationDbContext : DbContext
{
    public DbSet<User> Users { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
    }

    public ApplicationDbContext() : base("name=MyConnectionString")
    {
    }
}

<connectionStrings>
    <add name="MyConnectionString" connectionString="server=localhost;port=3306;database=mydatabase;uid=root;password=mypassword;" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>

public class UserController : Controller
{
    private readonly ApplicationDbContext _context;

    public UserController(ApplicationDbContext context)
    {
        _context = context;
    }

    // 增加用户
    public ActionResult AddUser(User user)
    {
        _context.Users.Add(user);
        _context.SaveChanges();
        return RedirectToAction("Index");
    }

    // 删除用户
    public ActionResult DeleteUser(int id)
    {
        var user = _context.Users.Find(id);
        if (user != null)
        {
            _context.Users.Remove(user);
            _context.SaveChanges();
        }
        return RedirectToAction("Index");
    }

    // 更新用户
    public ActionResult UpdateUser(User user)
    {
        _context.Entry(user).State = EntityState.Modified;
        _context.SaveChanges();
        return RedirectToAction("Index");
    }

    // 查询用户
    public ActionResult Index()
    {
        var users = _context.Users.ToList();
        return View(users);
    }
}