public static SqlSugarClient GetInstance() { string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var db = new SqlSugarClient(connection); db.SetSerialNumber(SugarConfigs.NumList);//设置流水号 return(db); }
public static SqlSugarClient GetInstance() { string connection = System.Configuration.ConfigurationManager.ConnectionStrings[@"sqlConn"].ToString(); //这里可以动态根据cookies或session实现多库切换 var reval = new SqlSugarClient(connection); //设置流水号 reval.SetSerialNumber(_nums); return(reval); }
public static SqlSugarClient GetInstance() { string connection = "DataSource=" + System.AppDomain.CurrentDomain.BaseDirectory + "App_Data\\demo.sqlite";; //这里可以动态根据cookies或session实现多库切换; //这里可以动态根据cookies或session实现多库切换 var reval = new SqlSugarClient(connection); //设置流水号 reval.SetSerialNumber(_nums); return(reval); }
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); }
public void SetSerialNumber(List <SerialNumber> serNum) { var values = new List <SqlSugar.PubModel.SerialNumber>(); foreach (var item in serNum) { var value = new SqlSugar.PubModel.SerialNumber() { FieldName = item.FieldName, TableName = item.TableName, GetNumFunc = item.GetNumFunc, }; if (value.GetNumFuncWithDb != null) { value.GetNumFunc = () => { return(item.GetNumFuncWithDb(this)); }; } } _db.SetSerialNumber(values); }