static void Main()
{
var context = new AdsEntities();
//long time = TestSlowSelect(context);
//Console.WriteLine(time);
long time = TestSlowSelect(context);
Console.WriteLine(time);
Console.ReadLine();
}
public static long TestSlowSelect(AdsEntities context)
{
context.Database.SqlQuery <string>("CHECKPOINT");
context.Database.SqlQuery <string>("DBCC DROPCLEANBUFFERS");
var stopWatch = new Stopwatch();
stopWatch.Start();
var ads = context.Ads;
foreach (var ad in ads)
{
Console.WriteLine(ad.Title);
}
long time = stopWatch.ElapsedMilliseconds;
return(time);
}