sqlsugar

// 定义实体类
public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 初始化数据库连接
var db = SqlSugarClient.GetInstance();

// 新增
var user = new User { Name = "John" };
db.Insertable(user).ExecuteCommand();

// 查询
var userList = db.Queryable<User>().Where(u => u.Name == "John").ToList();

// 更新
db.Updateable(user).ExecuteCommand();

// 删除
db.Deleteable<User>().Where(u => u.Id == 1).ExecuteCommand();