private static void SqlSugar(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "SqlSugar like ", () =>
{
SqlSugarClient conn = Config.GetSugarConn();
var list2 = conn.Queryable <Test>().Where(it => it.F_String.Contains("abc")).ToList();
});
}
private static void SqlSugar(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "SqlSugar", () =>
{
SqlSugarClient conn = Config.GetSugarConn();
var list2 = conn.Ado.SqlQuery <Test>("select top 20 * from Test");;
});
}
private static void EF(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "EF", () =>
{
using (EFContext conn = new EFContext(Config.connectionString))
{
var list = conn.TestList.AsNoTracking().ToList();
}
});
}
private static void Dapper(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "Dapper", () =>
{
using (SqlConnection conn = new SqlConnection(Config.connectionString))
{
var list = conn.GetAll <Test>();
}
});
}
private static void SqlSugar(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "SqlSugar", () =>
{
using (SqlSugarClient conn = Config.GetSugarConn())
{
var list2 = conn.Queryable <Test>().ToList();
}
});
}
private static void EF(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "EF", () =>
{
using (EFContext conn = new EFContext(Config.connectionString))
{
var list = conn.Database.SqlQuery <Test>("select top 20 * from Test").ToList();
}
});
}
private static void Free(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "Free like ", () =>
{
IFreeSql fsql = new FreeSql.FreeSqlBuilder()
.UseConnectionString(FreeSql.DataType.SqlServer, Config.connectionString)
.UseAutoSyncStructure(false) //自动同步实体结构到数据库
.Build();
var list2 = fsql.Queryable <Test>().Where(it => it.F_String.Contains("abc")).ToList();
});
}
private static void SqlSugar(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "SqlSugar", () =>
{
using (SqlSugarClient conn = Config.GetSugarConn())
{
var list2 = conn.Queryable <PerformanceTest.Models2.Group>()
.Mapper(it => it.AUsers, it => it.AUsers.First().AGroupId).Take(20).ToList();
}
});
}
private static void Free(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
IFreeSql fsql = new FreeSql.FreeSqlBuilder()
.UseConnectionString(FreeSql.DataType.SqlServer, Config.connectionString)
.UseAutoSyncStructure(false) //自动同步实体结构到数据库
.Build();
PerHelper.Execute(eachCount, "free", () =>
{
var list2 = fsql.Queryable <Group>().IncludeMany(it => it.AUsers).Take(20).ToList();
//用.First(it=>it.Id==1)报错
});
}
private static void Dapper(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "Dapper", () =>
{
using (SqlConnection conn = new SqlConnection(Config.connectionString))
{
conn.Insert(GetData());
}
});
//删除插入数据
DeleteAddData();
}
private static void EF(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "EF", () =>
{
using (EFContext conn = new EFContext(Config.connectionString))
{
conn.Set <Test>().Add(GetData());
conn.SaveChanges();
}
});
//删除插入数据
DeleteAddData();
}
private static void SqlSugar(int eachCount)
{
GC.Collect(); //回收资源
System.Threading.Thread.Sleep(1); //休息1秒
PerHelper.Execute(eachCount, "SqlSugar", () =>
{
using (SqlSugarClient conn = Config.GetSugarConn())
{
conn.Insertable(GetData()).ExecuteCommand();
}
});
//删除插入数据
DeleteAddData();
}
