private static void SimpleNinjaCompiledQuery()
{
using (var context = new nob.NinjaObjectContext())
{
var oldninjas = s_compiledNinjaQuery.Invoke(context, new DateTime(1982, 1, 1));
foreach (nob.Ninja ninja in oldninjas)
{
Console.Out.WriteLine(ninja.Name);
}
}
}
private static void CompiledQueryPerformanceTest()
{
for (var j = 0; j < 5; j++)
{
using (var context = new nob.NinjaObjectContext())
{
var start = DateTime.Now;
for (var i = 0; i < 10000; i++)
{
var result1 = s_compiledNinjaQuery.Invoke(context, new DateTime(1982, 1, 1));
}
double ms = (DateTime.Now - start).TotalMilliseconds;
Console.Out.WriteLine("Compiled query : " + ms.ToString() + "ms");
}
using (var ctx = new nob.NinjaObjectContext())
{
var start = DateTime.Now;
var date = new DateTime(1982, 1, 1);
for (var i = 0; i < 10000; i++)
{
var result2 = from ninja in ctx.Ninjas
where ninja.DateOfBirth < date
select ninja;
}
double ms = (DateTime.Now - start).TotalMilliseconds;
Console.Out.WriteLine("Non-Compiled query : " + ms.ToString() + "ms");
}
using (var ctx = new NinjaContext())
{
var start = DateTime.Now;
var date = new DateTime(1982, 1, 1);
for (var i = 0; i < 10000; i++)
{
var result2 = from ninja in ctx.Ninjas
where ninja.DateOfBirth < date
select ninja;
}
double ms = (DateTime.Now - start).TotalMilliseconds;
Console.Out.WriteLine("DbContext : " + ms.ToString() + "ms");
}
Console.Out.WriteLine("#######################");
}
}