private static void RunInsert(IDataProvider provider)
{
ResetDB(provider);
var repo = new SimpleRepository(provider);
Console.WriteLine("Inserting 1000 rows using Simple Repo: " + DateTime.Now + " using " + provider.Client);
DateTime start = DateTime.Now;
for (int i = 1; i < 1000; i++)
{
SubSonic.Tests.TestClasses.Product p = new SubSonic.Tests.TestClasses.Product();
p.CategoryID = 1;
p.Discontinued = false;
p.ProductName = "Product" + i;
p.Sku = Guid.NewGuid();
p.UnitPrice = 1000;
repo.Add(p);
//Console.WriteLine(i);
}
DateTime end = DateTime.Now;
TimeSpan ts = end.Subtract(start);
Console.WriteLine("End: " + DateTime.Now + " (" + ts.Seconds + ":" + ts.Milliseconds + ")");
}
private static void SelectIQueryable(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with IQueryable: " + DateTime.Now + " using " + provider.Name);
var db = new TestDB(provider);
DateTime start = DateTime.Now;
for (int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = db.Products.SingleOrDefault(x => x.ProductID == 1);
//Console.Write(i + ",");
}
WriteResult(start);
}
private static void SelectSimpleRepo(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with SimpleRepo: " + DateTime.Now + " using " + provider.Name);
var repo = new SimpleRepository(provider);
DateTime start = DateTime.Now;
for (int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = repo.Single <SubSonic.Tests.TestClasses.Product>(1);
//Console.Write(i + ",");
}
WriteResult(start);
}
private static void SelectIQueryable(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with IQueryable: " + DateTime.Now + " using " + provider.Client);
var db = new TestDB(provider);
DateTime start = DateTime.Now;
for (int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = db.Products.SingleOrDefault(x => x.ProductID == 1);
Console.WriteLine(i);
}
DateTime end = DateTime.Now;
TimeSpan ts = end.Subtract(start);
Console.WriteLine("End: " + DateTime.Now + " (" + ts.Seconds + ":" + ts.Milliseconds + ")");
}
private static void SelectSimpleRepo(IDataProvider provider)
{
Console.WriteLine("Selecting 10000 records with SimpleRepo: " + DateTime.Now + " using " + provider.Client);
var repo = new SimpleRepository(provider);
DateTime start = DateTime.Now;
for (int i = 1; i < 10000; i++)
{
SubSonic.Tests.TestClasses.Product p = repo.Single <SubSonic.Tests.TestClasses.Product>(1);
Console.WriteLine(i);
}
DateTime end = DateTime.Now;
TimeSpan ts = end.Subtract(start);
Console.WriteLine("End: " + DateTime.Now + " (" + ts.Seconds + ":" + ts.Milliseconds + ")");
}
private static void RunInsert(IDataProvider provider)
{
ResetDB(provider);
var repo = new SimpleRepository(provider);
Console.WriteLine("Inserting 1000 rows using Simple Repo: " + DateTime.Now + " using " + provider.Name);
DateTime start = DateTime.Now;
for (int i = 1; i < 1000; i++)
{
SubSonic.Tests.TestClasses.Product p = new SubSonic.Tests.TestClasses.Product();
p.CategoryID = 1;
p.Discontinued = false;
p.ProductName = "Product" + i;
p.Sku = Guid.NewGuid();
p.UnitPrice = 1000;
repo.Add(p);
//Console.Write(i + ",");
}
WriteResult(start);
}
private static void RunInsert(IDataProvider provider)
{
ResetDB(provider);
var repo = new SimpleRepository(provider);
Console.WriteLine("Inserting 1000 rows using Simple Repo: " + DateTime.Now + " using " + provider.Name);
DateTime start = DateTime.Now;
for (int i = 1; i < 1000; i++)
{
SubSonic.Tests.TestClasses.Product p = new SubSonic.Tests.TestClasses.Product();
p.CategoryID = 1;
p.Discontinued = false;
p.ProductName = "Product" + i;
p.Sku = Guid.NewGuid();
p.UnitPrice = 1000;
repo.Add(p);
//Console.Write(i + ",");
}
WriteResult(start);
}
private static void RunInsert(IDataProvider provider)
{
ResetDB(provider);
var repo = new SimpleRepository(provider);
Console.WriteLine("Inserting 1000 rows using Simple Repo: " + DateTime.Now + " using " + provider.Client);
DateTime start = DateTime.Now;
for(int i = 1; i < 1000; i++)
{
SubSonic.Tests.TestClasses.Product p = new SubSonic.Tests.TestClasses.Product();
p.CategoryID = 1;
p.Discontinued = false;
p.ProductName = "Product" + i;
p.Sku = Guid.NewGuid();
p.UnitPrice = 1000;
repo.Add(p);
//Console.WriteLine(i);
}
DateTime end = DateTime.Now;
TimeSpan ts = end.Subtract(start);
Console.WriteLine("End: " + DateTime.Now + " (" + ts.Seconds + ":" + ts.Milliseconds + ")");
}
