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.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 + ")"); }