SqlSugarClient怎么使用的

SqlSugarClient是一个基于SqlSugar的ORM框架，用于与数据库进行交互。以下是SqlSugarClient的使用示例：

创建SqlSugarClient对象

SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
    ConnectionString = "server=127.0.0.1;database=mydb;uid=root;pwd=123456;",
    DbType = DbType.MySql,
    IsAutoCloseConnection = true
});

插入数据

var user = new User() { Name = "张三", Age = 20 };
db.Insertable(user).ExecuteCommand();

查询数据

var userList = db.Queryable<User>().ToList();

更新数据

var user = db.Queryable<User>().Where(u => u.Id == 1).First();
user.Name = "李四";
db.Updateable(user).ExecuteCommand();

删除数据

db.Deleteable<User>().Where(u => u.Id == 1).ExecuteCommand();
``