public bool GetSingleColumnSlow(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); for (var i = 0; i < repeatCount; i++) { using (var db = new BLTContext()) db.SetCommand(GetSingleColumnSql).ExecuteScalar <int>(); } watch.Stop(); return(true); }
public bool GetSingleColumnParam(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); using (var db = new BLTContext()) for (var i = 0; i < repeatCount; i++) { db.SetCommand(GetParamSql, db.Parameter("@id", 1), db.Parameter("@p", 2)) .ExecuteScalar <int>(); } watch.Stop(); return(true); }
public bool GetWideList(Stopwatch watch, int repeatCount, int takeCount) { var sql = GetWideListSql(takeCount); watch.Start(); for (var i = 0; i < repeatCount; i++) { using (var db = new BLTContext()) foreach (var item in db.SetCommand(sql).ExecuteList(new List <WideLong>(takeCount))) { } } watch.Stop(); return(true); }