protected void Page_Load(object sender, EventArgs e)
{
PerformanceTest pt = new PerformanceTest();
pt.SetCount(10000);//设置循环次数
using (SqlSugarClient db = new SqlSugarClient(System.Configuration.ConfigurationManager.ConnectionStrings["sqlConn"].ToString()))
{
//ef
using (WebTest.TestLib.SqlSugarTestEntities ef = new TestLib.SqlSugarTestEntities())
{
pt.Execute(i =>
{
var datas = ef.InsertTests.Where(c => c.id == 1 || c.id > 1000);
foreach (var r in datas)
{
r.v1 = "new11";
r.v2 = "newv22";
r.v3 = "new33";
}
ef.SaveChanges();
}, m => { }, "EF4.0+sql05 Linq语法");
}
//ado.net
pt.Execute(i =>
{
db.ExecuteCommand(@" UPDATE InsertTest SET v1 =@v1 , v2 =@v2 , v3 =@v3 WHERE 1=1 and ((id =@id1) Or (id >@id1000))", new SqlParameter[] {
new SqlParameter("@v1", "new11"),
new SqlParameter("@v2", "new22"),
new SqlParameter("@v3", "new33"),
new SqlParameter("@id1", "1"),
new SqlParameter("@id1000", "1000")
});
}, m => { }, "ado.net");
//dapper
var sqlConn = db.GetConnection();
pt.Execute(i =>
{
sqlConn.Execute(@" UPDATE InsertTest SET v1 =@v1 , v2 =@v2 , v3 =@v3 WHERE 1=1 and ((id ='1') Or (id >'1000'))",
new { v1 = "newv11", v2 = "newv22", v3 = "newv33", id1 = 1, id1000 = 1000 });
}, m => { }, "dapper");
//sqlSugar
pt.Execute(i =>
{
//更新10000次
db.Update <Models.InsertTest>(new { v1 = "newv11", v2 = "newv22", v3 = "newv33" }, it => it.id == 1 || it.id > 1000);
}, m => { }, "sqlSugar");
}
//输出测试页面
GridView gv = new GridView();
gv.DataSource = pt.GetChartSource();
gv.DataBind();
Form.Controls.Add(gv);
}
protected void Page_Load(object sender, EventArgs e)
{
PerformanceTest pt = new PerformanceTest();
pt.SetCount(10000);//设置循环次数
using (SqlSugarClient db = new SqlSugarClient(System.Configuration.ConfigurationManager.ConnectionStrings["sqlConn"].ToString()))
{
//ef
using (WebTest.TestLib.SqlSugarTestEntities ef = new TestLib.SqlSugarTestEntities())
{
pt.Execute(i =>
{
var datas = ef.InsertTests.Where(c => c.id == 1 || c.id > 1000);
foreach (var r in datas)
{
r.v1 = "new11";
r.v2 = "newv22";
r.v3 = "new33";
}
ef.SaveChanges();
}, m => { }, "EF4.0+sql05 Linq语法");
}
//ado.net
pt.Execute(i =>
{
db.ExecuteCommand(@" UPDATE InsertTest SET v1 =@v1 , v2 =@v2 , v3 =@v3 WHERE 1=1 and ((id =@id1) Or (id >@id1000))",new SqlParameter[]{
new SqlParameter("@v1","new11"),
new SqlParameter("@v2","new22"),
new SqlParameter("@v3","new33"),
new SqlParameter("@id1","1"),
new SqlParameter("@id1000","1000")
});
}, m => { },"ado.net");
//dapper
var sqlConn=db.GetConnection();
pt.Execute(i =>
{
sqlConn.Execute(@" UPDATE InsertTest SET v1 =@v1 , v2 =@v2 , v3 =@v3 WHERE 1=1 and ((id ='1') Or (id >'1000'))",
new { v1 = "newv11", v2 = "newv22", v3 = "newv33",id1=1,id1000=1000 } );
}, m => { }, "dapper");
//sqlSugar
pt.Execute(i =>
{
//更新10000次
db.Update<Models.InsertTest>(new { v1 = "newv11", v2 = "newv22", v3 = "newv33" }, it => it.id == 1 || it.id > 1000);
}, m => { }, "sqlSugar");
}
//输出测试页面
GridView gv = new GridView();
gv.DataSource = pt.GetChartSource();
gv.DataBind();
Form.Controls.Add(gv);
}
protected void Page_Load(object sender, EventArgs e)
{
PerformanceTest pt = new PerformanceTest();
pt.SetCount(10000);//设置循环次数
using (SqlSugarClient db = new SqlSugarClient(System.Configuration.ConfigurationManager.ConnectionStrings["sqlConn"].ToString()))
{
var sqlconn = db.GetConnection();
TuncateTable(db);//清空
//sqlSuagr
pt.Execute(i =>
{
db.Insert <Models.InsertTest>(GetData());
}, m => { }, "sqlSuagr");
TuncateTable(db);
//ef4.0+Sql05
using (TestLib.SqlSugarTestEntities ef = new TestLib.SqlSugarTestEntities())
{
pt.Execute(i =>
{
ef.InsertTests.AddObject(GetEFData());
ef.SaveChanges();
}, m => { }, "ef4.0+Sql05");
}
TuncateTable(db);
//dapper
pt.Execute(i =>
{
sqlconn.Execute("insert into InsertTest (v1,v2,v3,int1,d1,txt ) values(@v1,@v2,@v3,@int1,@d1,@txt);select @@identity;", GetData());
}, m => { }, "dapper");
TuncateTable(db);
//ado.net
pt.Execute(i =>
{
db.GetScalar("insert into InsertTest (v1,v2,v3,int1,d1,txt ) values(@v1,@v2,@v3,@int1,@d1,@txt);select @@identity;", new SqlParameter[] {
new SqlParameter("@d1", DateTime.Now),
new SqlParameter("@int1", 11),
new SqlParameter("@txt", "哈另一个txt"),
new SqlParameter("@v1", "v1sdfasdas"),
new SqlParameter("@v2", "v2sdfasfas"),
new SqlParameter("@v3", "v3adfasdf"),
new SqlParameter("@id", 1)
});
}, m => { }, "ado.net");
}
//输出测试页面
GridView gv = new GridView();
gv.DataSource = pt.GetChartSource();
gv.DataBind();
Form.Controls.Add(gv);
}
protected void Page_Load(object sender, EventArgs e)
{
PerformanceTest pt = new PerformanceTest();
pt.SetCount(10000);//设置循环次数
using (SqlSugarClient db = new SqlSugarClient(System.Configuration.ConfigurationManager.ConnectionStrings["sqlConn"].ToString()))
{
var sqlconn = db.GetConnection();
TuncateTable(db);//清空
//sqlSuagr
pt.Execute(i =>
{
db.Insert<Models.InsertTest>(GetData());
}, m => { }, "sqlSuagr");
TuncateTable(db);
//ef4.0+Sql05
using (TestLib.SqlSugarTestEntities ef = new TestLib.SqlSugarTestEntities())
{
pt.Execute(i =>
{
ef.InsertTests.AddObject(GetEFData());
ef.SaveChanges();
}, m => { }, "ef4.0+Sql05");
}
TuncateTable(db);
//dapper
pt.Execute(i =>
{
sqlconn.Execute("insert into InsertTest (v1,v2,v3,int1,d1,txt ) values(@v1,@v2,@v3,@int1,@d1,@txt);select @@identity;", GetData());
}, m => { }, "dapper");
TuncateTable(db);
//ado.net
pt.Execute(i =>
{
db.GetScalar("insert into InsertTest (v1,v2,v3,int1,d1,txt ) values(@v1,@v2,@v3,@int1,@d1,@txt);select @@identity;", new SqlParameter[]{
new SqlParameter("@d1", DateTime.Now),
new SqlParameter("@int1",11),
new SqlParameter("@txt","哈另一个txt"),
new SqlParameter("@v1","v1sdfasdas"),
new SqlParameter("@v2","v2sdfasfas"),
new SqlParameter("@v3","v3adfasdf"),
new SqlParameter("@id",1)
});
}, m => { }, "ado.net");
}
//输出测试页面
GridView gv = new GridView();
gv.DataSource = pt.GetChartSource();
gv.DataBind();
Form.Controls.Add(gv);
}
