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;
}
