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