public static void Main(string[] args)
{
using (SqlSugarClient db = new SqlSugarClient("server=.;uid=sa;pwd=sasa;database=SqlSugarTest"))
{
var dt = db.GetDataTable("select * from student where id=@id", new { id = 1 });
//设置执行的DEMO
string switch_on = "CreateClass";
IDemos demo = null;
switch (switch_on)
{
//ADO.NET基本功能
case "Ado": demo = new Ado(); break;
//查询
case "Select": demo = new Select(); break;
//插入
case "Insert": demo = new Insert(); break;
//更新
case "Update": demo = new Update(); break;
//删除
case "Delete": demo = new Delete(); break;
//事务
case "Tran": demo = new Tran(); break;
//生成实体
case "CreateClass": demo = new CreateClass(); break;
//枚举类型的支持
case "EnumType": demo = new EnumType(); break;
//除了多库并行计算外的所有功能都已经移植成功更多例子请关注我的博客
}
//执行DEMO
demo.Init();
//更多例子请查看API
//http://www.cnblogs.com/sunkaixuan/p/5654695.html
Console.WriteLine("执行成功请关闭窗口 ,更多例子请查看API:http://www.cnblogs.com/sunkaixuan/p/5654695.html");
Console.ReadKey();
}
}
/// <summary>
/// SqlSugar与Dapper的性能比较
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
WarmUp wu = new WarmUp();//预热处理
//设置执行的DEMO
string switchOn = "4";
IDemos demo = null;
switch (switchOn)
{
//查询所有
case "1": demo = new SelectBigData(); break;
//查询单条
case "2": demo = new SelectSingle(); break;
//比拼海量数据更新
case "3": demo = new UpdateList(); break;
//比拼海量数据插入
case "4": demo = new InsertList(); break;
//比拼批量删除
case "5": demo = new DeleteArray(); break;
//分页
case "6": demo = new Page(); break;
//比拼普通插入
case "7": demo = new InsertItem(); break;
//比拼普通更新
case "8": demo = new UpdateItem(); break;
default: Console.WriteLine("switchOn的值错误，请输入正确的 case"); break;
}
demo.Init();
Console.WriteLine("执行成功请关闭窗口");
Console.ReadKey();
}
public static void Main(string[] args)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
//设置执行的DEMO
string switchOn = "update";
IDemos demo = null;
switch (switchOn)
{
/****************************基本功能**************************************/
//查询
case "select": demo = new Select(); break;
//删除
case "delete": demo = new Delete(); break;
//插入
case "insert": demo = new Insert(); break;
//更新
case "update": demo = new Update(); break;
//基层函数的用法
case "ado": demo = new Ado(); break;
//事务
case "tran": demo = new Tran(); break;
//创建实体函数
case "createclass": demo = new CreateClass(); break;
//T4生成 http://www.cnblogs.com/sunkaixuan/p/5751503.html
//日志记录
case "log": demo = new Log(); break;
//枚举支持
case "enum": demo = new EnumDemo(); break;
/****************************实体映射**************************************/
//自动排除非数据库列
case "ignoreerrorcolumns": demo = new IgnoreErrorColumns(); break;
//别名表
case "mappingtable": demo = new MappingTable(); break;
//别名列
case "mappingcolumns": demo = new MappingColumns(); break;
//通过属性的方法设置别名表和别名字段
case "attributesmapping": demo = new AttributesMapping(); break;
/****************************业务应用**************************************/
//过滤器
case "filter": demo = new Filter(); break;
//过滤器2
case "filter2": demo = new Filter2(); break;
//流水号功能
case "serialnumber": demo = new SerialNumber(); break;
//配置与实例的用法
case "initconfig": demo = new InitConfig(); break;
/****************************支持**************************************/
//公开函数数
case "pubmethod": demo = new PubMethod(); break;
//设置ToJson的日期格式
case "serializerdateformat": demo = new SerializerDateFormat(); break;
/****************************测试用例**************************************/
case "test": demo = new Test(); break;
default: Console.WriteLine("switchOn的值错误，请输入正确的 case"); break;
}
//执行DEMO
demo.Init();
//更多例子请查看API
//http://www.cnblogs.com/sunkaixuan/p/5654695.html
Console.WriteLine("执行成功请关闭窗口");
Console.ReadKey();
}
/// <summary>
/// SqlSugar的功能介绍
/// </summary>
/// <param name="args"></param>
private static void Main(string[] args)
{
// 设置执行的DEMO
var switchOn = "ignoreerrorcolumns";
IDemos demo = null;
switch (switchOn)
{
#region 基本功能
// 查询
case "select":
demo = new SelectTest();
break;
// 删除
case "delete":
demo = new DeleteTest();
break;
// 插入
case "insert":
demo = new InsertTest();
break;
// 更新
case "update":
demo = new UpdateTest();
break;
// 基层函数的用法
case "ado":
demo = new AdoTest();
break;
// 事务
case "tran":
demo = new TranTest();
break;
// 创建实体函数
case "createclass":
demo = new CreateClassTest();
break;
// 日志记录
case "log":
demo = new LogTest();
break;
// 枚举支持
case "enum":
demo = new EnumDemoTest();
break;
#endregion
#region 实体映射
// 自动排除非数据库列
case "ignoreerrorcolumns":
demo = new IgnoreErrorColumnsTest();
break;
// 别名表
case "mappingtable":
demo = new MappingTableTest();
break;
// 别名列
case "mappingcolumns":
demo = new MappingColumnsTest();
break;
// 通过属性的方法设置别名表和别名字段
case "attributesmapping":
demo = new AttributesMappingTest();
break;
#endregion
#region 业务应用
// 过滤器
case "filter":
demo = new FilterTest();
break;
// 过滤器2
case "filter2":
demo = new Filter2Test();
break;
// 流水号功能
case "serialnumber":
demo = new SerialNumberTest();
break;
// 多语言支持 http://www.cnblogs.com/sunkaixuan/p/5709583.html
// 多库并行计算 http://www.cnblogs.com/sunkaixuan/p/5046517.html
// 配置与实例的用法
case "initconfig":
demo = new InitConfigTest();
break;
#endregion
#region 支持
// 公开函数数
case "pubmethod":
demo = new PubMethodTest();
break;
// Sql2012分页的支持
case "sqlpagemodel":
demo = new SqlPageModelTest();
break;
// 设置ToJson的日期格式
case "serializerdateformat":
demo = new SerializerDateFormatTest();
break;
#endregion
#region 测试用例
case "test":
demo = new UnitTest();
break;
default:
Console.WriteLine("switchOn的值错误，请输入正确的 case");
break;
#endregion
}
if (demo == null)
{
return;
}
// 执行DEMO
demo.Init();
Console.WriteLine("执行成功请关闭窗口");
Console.ReadKey();
}
public static void Main(string[] args)
{
//解决Core输出中文乱码
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
//设置执行的DEMO
string switchOn = "select";
IDemos demo = null;
switch (switchOn)
{
//查询
case "select": demo = new Select(); break;
//删除
case "delete": demo = new Delete(); break;
//插入
case "insert": demo = new Insert(); break;
//更新
case "update": demo = new Update(); break;
//基层函数的用法
case "ado": demo = new Ado(); break;
//事务
case "tran": demo = new Tran(); break;
//创建实体函数
case "createclass": demo = new CreateClass(); break;
//日志记录
case "log": demo = new Log(); break;
//枚举支持
case "enum": demo = new EnumDemo(); break;
//别名表
case "mappingtable": demo = new MappingTable(); break;
//过滤器
case "filter": demo = new Filter(); break;
//过滤器2
case "filter2": demo = new Filter2(); break;
//自动排除非数据库列
case "ignoreerrorcolumns": demo = new IgnoreErrorColumns(); break;
//流水号功能
case "serialnumber": demo = new SerialNumber(); break;
//公开含数
case "pubmethod": demo = new PubMethod(); break;
//Sql2012分页的支持
case "sqlpagemodel": demo = new SqlPageModel(); break;
//设置ToJson的日期格式
case "serializerdateformat": demo = new SerializerDateFormat(); break;
default: Console.WriteLine("switchOn的值错误，请输入正确的 case"); break;
}
//执行DEMO
demo.Init();
//更多例子请查看API
//http://www.cnblogs.com/sunkaixuan/p/5654695.html
Console.WriteLine("执行成功请关闭窗口");
Console.ReadKey();
}
