微信商城怎么开_小米手机优化_seo引擎优化是什么_网站排行

1 特点 Sqlsugar是一款轻量级的ORM，支持DB First、Code First、Model First,大量语法糖，Lambda表达式，支持大部分数据库。

2 sqlsugar连接

public static SqlSugarClient SqlSugarClient{get{return new SqlSugarClient(new ConnectionConfig(){DbType = SetDBType(ConfigurationManager.AppSettings["DBType"]), //配置数据库类型ConnectionString = ConfigurationManager.AppSettings["ConnectionString"],  //数据库连接字符串IsAutoCloseConnection = true,//设置为true无需使用using或者Close操作，自动关闭连接，不需要手动关闭数据链接InitKeyType = InitKeyType.SystemTable//默认SystemTable, 字段信息读取, 如：该属性是不是主键，是不是标识列等等信息});}}public static DbType SetDBType(string dbType){string sql = ConfigurationManager.AppSettings["DBType"];DbType DBType;switch (dbType.ToLower()){case "sqlserver":DBType = DbType.SqlServer;break;case "sqlite":DBType = DbType.Sqlite;break;case "mysql":DBType = DbType.MySql;break;default:DBType = DbType.MySql;break;}return DBType;}

3 CRUD操作

增

DbClass.SqlSugarClient.Insertable<EmployeeCheck>(info).ExecuteCommand()

删

DbClass.SqlSugarClient.Deleteable<CheckListInfo>().Where(d => d.ID == id).ExecuteCommand()

改

DbClass.SqlSugarClient.Updateable<ChangeListInfo>(info).Where(o=>o.ID== m_ID).ExecuteCommand()

查

DataTable listInfos =DbClass.SqlSugarClient.Queryable<ChangeListInfo>().OrderBy(d => d.IsueDate).ToDataTable();DataTable dt = DbClass.SqlSugarClient.SqlQueryable<InspectedProduct>(sql).ToDataTable();