如何使用Tinyint(1) MySQL EF内核

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  is_active TINYINT(1)
);

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

// 插入数据
var user = new User
{
    Id = 1,
    Name = "John",
    IsActive = true
};

using (var context = new MyDbContext())
{
    context.Users.Add(user);
    context.SaveChanges();
}

// 查询数据
using (var context = new MyDbContext())
{
    var activeUsers = context.Users.Where(u => u.IsActive).ToList();
    // 处理查询结果
}

// 更新数据
using (var context = new MyDbContext())
{
    var user = context.Users.FirstOrDefault(u => u.Id == 1);
    if (user != null)
    {
        user.IsActive = false;
        context.SaveChanges();
    }
}