SqlSugar使用
1 特点 Sqlsugar是一款轻量级的ORM,支持DB First、Code First、Model First,大量语法糖,Lambda表达式,支持大部分数据库。
2 sqlsugar连接
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 public static SqlSugarClient SqlSugarClient 2 { 3 get 4 { 5 return new SqlSugarClient(new ConnectionConfig() 6 { 7 DbType = SetDBType(ConfigurationManager.AppSettings["DBType"]), //配置数据库类型 8 ConnectionString = ConfigurationManager.AppSettings["ConnectionString"], //数据库连接字符串 9 IsAutoCloseConnection = true,//设置为true无需使用using或者Close操作,自动关闭连接,不需要手动关闭数据链接 10 InitKeyType = InitKeyType.SystemTable//默认SystemTable, 字段信息读取, 如:该属性是不是主键,是不是标识列等等信息 11 }); 12 } 13 } 14 public static DbType SetDBType(string dbType) 15 { 16 string sql = ConfigurationManager.AppSettings["DBType"]; 17 DbType DBType; 18 switch (dbType.ToLower()) 19 { 20 case "sqlserver": 21 DBType = DbType.SqlServer; 22 break; 23 case "sqlite": 24 DBType = DbType.Sqlite; 25 break; 26 case "mysql": 27 DBType = DbType.MySql; 28 break; 29 default: 30 DBType = DbType.MySql; 31 break; 32 } 33 return DBType; 34 }
3 CRUD操作
增
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
DbClass.SqlSugarClient.Insertable<EmployeeCheck>(info).ExecuteCommand()
删
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
DbClass.SqlSugarClient.Deleteable<CheckListInfo>().Where(d => d.ID == id).ExecuteCommand()
改
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
DbClass.SqlSugarClient.Updateable<ChangeListInfo>(info).Where(o=>o.ID== m_ID).ExecuteCommand()
查
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
DataTable listInfos =DbClass.SqlSugarClient.Queryable<ChangeListInfo>().OrderBy(d => d.IsueDate).ToDataTable();
DataTable dt = DbClass.SqlSugarClient.SqlQueryable<InspectedProduct>(sql).ToDataTable();