protected void Page_Load(object sender, EventArgs e) { using (SqlSugarClient db = SugarDao.GetInstance()) { //-----单个-------// var list = db.Queryable <V_Student>("Student").ToList();//查询的是 select * from student 而我的实体名称为V_Student //-----全局多个设置-------// //设置 Mapping Table 如果没这方面需求可以传NULL List <KeyValue> mappingTableList = new List <KeyValue>() { new KeyValue() { Key = "FormAttr", Value = "Flow_FormAttr" }, new KeyValue() { Key = "Student3", Value = "Student" } }; db.SetMappingTables(mappingTableList); } }
public void SetMappingTables(List <KeyValue> mappingTables) { _db.SetMappingTables(mappingTables.Select(it => new SqlSugar.KeyValue() { Key = it.Key, Value = it.Value }).ToList()); }
public static SqlSugarClient GetInstance() { string connection = System.Configuration.ConfigurationManager.ConnectionStrings[@"sqlConn"].ToString(); //这里可以动态根据cookies或session实现多库切换 var reval= new SqlSugarClient(connection); reval.SetMappingTables(_mappingTables); return reval; }
public static SqlSugarClient GetInstance() { string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var db = new SqlSugarClient(connection); db.SetMappingTables(SugarConfigs.MpList);//设置关联表 (引用地址赋值,每次赋值都只是存储一个内存地址) return(db); }
public static SqlSugarClient GetInstance() { string connection = System.Configuration.ConfigurationManager.ConnectionStrings[@"sqlConn"].ToString(); //这里可以动态根据cookies或session实现多库切换 var reval = new SqlSugarClient(connection); reval.SetMappingTables(_mappingTables); return(reval); }
public static SqlSugarClient GetInstance() { string connection = SqlServerConnString; var db = new SqlSugarClient(connection); // 设置关联表 (引用地址赋值,每次赋值都只是存储一个内存地址) db.SetMappingTables(SugarConfigs.MpList); return(db); }
/// <summary> /// 获取Sugar客户端实例对象 /// </summary> /// <returns>SqlSugarClient</returns> public static SqlSugarClient GetInstance() { string connection = System.Configuration.ConfigurationManager.ConnectionStrings[@"AppSoft.IO_ConnStr"].ToString(); SqlSugarClient _SqlSugarClient = new SqlSugarClient(connection); // 映射表,解决类名和表名不一致情况,通常体现在表名加前缀,类名不加 _SqlSugarClient.SetMappingTables(_MappingTables); return(_SqlSugarClient); }
public static SqlSugarClient GetInstance() { var connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var db = new SqlSugarClient(connection); db.SetMappingTables(SugarConfigs.MpList); //设置关联表 (引用地址赋值,每次赋值都只是存储一个内存地址) //批量设置别名表 //db.ClassGenerating.ForeachTables(db, tableName => //{ // db.AddMappingTable(new KeyValue() { Key = tableName.Replace("bbs.",""), Value = tableName }); //key实体名,value表名 //}); return(db); }
public static SqlSugarClient GetInstance() { string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var db = new SqlSugarClient(connection); /**这种写法只给db对象添加了4个指向地址(DaoInitConfig变量都为静态对象),并非指向内容,指向内容初始化后存储在内存当中,所以性能就不用说了 **/ db.SetMappingTables(GetMappingTables(db)); //设置别名表 db.SetMappingColumns(DaoInitConfig.columnMappingList); //设置别名列 db.SetSerialNumber(DaoInitConfig.serialNumber); //设置流水号 db.IsIgnoreErrorColumns = DaoInitConfig.IsIgnoreErrorColumns; //自动排除非数据库列 return(db); }
protected void Page_Load(object sender, EventArgs e) { using (SqlSugarClient db = SugarDao.GetInstance()) { //设置别名表具体列子看rename.aspx db.SetMappingTables(new List <KeyValue>() { new KeyValue() { Key = "MyStudent", Value = "Student" }, }); //数据库并没有appendField和appendField2二个字段,设置该属性后将插入可以正常使用 db.IsIgnoreErrorColumns = true;//自动排除非数据库列 update也一样 db.Insert <MyStudent>(new MyStudent() { name = "张三" }); //将实体MyStudent插入Student表 } }
public DbService() { _db = new SqlSugarClient(_connection);//获SqlSugarClient对象 _db.SetMappingTables(SugarConfigs.MpList); }