public static SqlSugarClient GetInstance() { string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var reval = new SqlSugarClient(connection); //支持sqlable和queryable reval.SetFilterFilterParas(_filterParas); //列过滤只支持queryable reval.SetFilterFilterParas(_filterColumns); return(reval); }
public static SqlSugarClient GetInstance() { string connection = System.Configuration.ConfigurationManager.ConnectionStrings[@"sqlConn"].ToString(); //这里可以动态根据cookies或session实现多库切换 var reval = new SqlSugarClient(connection); //支持sqlable和queryable reval.SetFilterFilterParas(_filterParas); //列过滤只支持queryable reval.SetFilterFilterParas(_filterColumns); return(reval); }
public static SqlSugarClient GetInstance() { string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换 var db = new SqlSugarClient(connection); //支持sqlable和queryable db.SetFilterFilterParas(_filterRos); //列过滤只支持queryable db.SetFilterFilterParas(_filterColumns); db.IsEnableLogEvent = true;//启用日志事件 db.LogEventStarting = (sql, par) => { Console.WriteLine(sql + " " + par + "\r\n"); }; return(db); }
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.SetFilterFilterParas(_filterParas); return(reval); }
public DbServices() { var db = new SqlSugarClient(ConnectionString); db.SetFilterFilterParas(RowFilter); db.DisableInsertColumns = InsertColumnsFilter; db.DisableUpdateColumns = UpdateColumnsFilter; db.CurrentFilterKey = "all"; this._db = db; }