Winform中如何使用SqlSugar

在 Winform 中使用 SqlSugar 首先需要安装 SqlSugar 包，可以通过 NuGet 包管理器搜索并安装 SqlSugar。

using SqlSugar;public class DatabaseContext{    private SqlSugarClient db;    public DatabaseContext()    {        db = new SqlSugarClient(new ConnectionConfig()        {            ConnectionString = "YourConnectionString",            DbType = DbType.SqlServer,            IsAutoCloseConnection = true        });    }    public List<T> GetAll<T>() where T : class, new()    {        return db.Queryable<T>().ToList();    }    public T GetById<T>(object id) where T : class, new()    {        return db.Queryable<T>().InSingle(id);    }    public void Insert<T>(T entity) where T : class, new()    {        db.Insertable(entity).ExecuteCommand();    }    public void Update<T>(T entity) where T : class, new()    {        db.Updateable(entity).ExecuteCommand();    }    public void Delete<T>(T entity) where T : class, new()    {        db.Deleteable(entity).ExecuteCommand();    }}

在 Winform 窗体中使用 DatabaseContext 类来进行数据库操作：

private void btnGetAll_Click(object sender, EventArgs e){    DatabaseContext dbContext = new DatabaseContext();    var data = dbContext.GetAll<YourEntity>();    dataGridView.DataSource = data;}private void btnInsert_Click(object sender, EventArgs e){    DatabaseContext dbContext = new DatabaseContext();    YourEntity entity = new YourEntity { Name = "Test" };    dbContext.Insert(entity);}private void btnUpdate_Click(object sender, EventArgs e){    DatabaseContext dbContext = new DatabaseContext();    YourEntity entity = dbContext.GetById<YourEntity>(1);    entity.Name = "Updated";    dbContext.Update(entity);}private void btnDelete_Click(object sender, EventArgs e){    DatabaseContext dbContext = new DatabaseContext();    YourEntity entity = dbContext.GetById<YourEntity>(1);    dbContext.Delete(entity);}

在上面的代码中，需要将 “YourConnectionString” 替换为实际的数据库连接字符串，以及将 “YourEntity” 替换为实际的实体类名称。通过 DatabaseContext 类的方法实现数据库的增删改查操作，并在 Winform 窗体的按钮点击事件中调用这些方法来操作数据库。