阅读量:0
在 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 窗体的按钮点击事件中调用这些方法来操作数据库。
