static void Main(string[] args)
{
using (CustomAdventureWorksContext context = new CustomAdventureWorksContext())
{
DateTime start = DateTime.Now;
var p1 = context.Person.Take(10);
Console.WriteLine($"1st query {start - DateTime.Now}");
}
using (CustomAdventureWorksContext context = new CustomAdventureWorksContext())
{
DateTime start = DateTime.Now;
var p2 = context.PersonCreditCard.Take(10);
Console.WriteLine($"2nd query {start - DateTime.Now}");
}
using (CustomAdventureWorksContext context = new CustomAdventureWorksContext())
{
DateTime start = DateTime.Now;
var p3 = context.Location.Take(10);
Console.WriteLine($"3rd query {start - DateTime.Now}");
}
using (CustomAdventureWorksContext context = new CustomAdventureWorksContext())
{
DateTime start = DateTime.Now;
var p4 = context.ProductPhoto.Take(10);
Console.WriteLine($"4th query {start - DateTime.Now}");
}
using (CustomAdventureWorksContext context = new CustomAdventureWorksContext())
{
DateTime start = DateTime.Now;
var p5 = context.Illustration.Take(10);
Console.WriteLine($"5th query {start - DateTime.Now}");
}
}
public BaseManager(ServiceFactory serviceFactory)
{
this.Context = serviceFactory.Context;
}
