private static void LoadAuthorsByFilter()
{
Console.Write("Enter name fragment: ");
var fragment = Console.ReadLine();
var loader = new AuthorsLoader(connectionString);
authors = loader.LoadAuthorsByFilter(fragment);
}
private static void SpinAuthorsDatabase()
{
Stopwatch s = Stopwatch.StartNew();
var loader = new AuthorsLoader(connectionString);
for (int i = 0; i < 100; i++)
{
var result = loader.LoadAuthorsByFilter("ew");
}
s.Stop();
Console.WriteLine($"Data: {s.ElapsedMilliseconds}");
}
private static void SpinAuthorsCode()
{
Stopwatch s = Stopwatch.StartNew();
var loader = new AuthorsLoader(connectionString);
var authors = loader.LoadAuthors();
for (int i = 0; i < 100; i++)
{
var result = authors.Where(a => a.Name.Contains("ew")).ToList();
}
s.Stop();
Console.WriteLine($"Code: {s.ElapsedMilliseconds}");
}
