private static int SelectPartTest(string connectionString)
 {
     var table = new Home("ORMTest");
     return table.All(where: "where BuildYear<@0", args: 2000).Count();
 }
 private static int Update100Test(string connectionString)
 {
     var table = new Home("ORMTest");
     var toUpdate = table.All("WHERE BuildYear=@0", args: 2014).ToArray();
     int counter = 0;
     foreach (var home in toUpdate)
     {
         home.BuildYear = 2015;
         counter++;
     }
     table.Save(toUpdate);
     return counter;
 }
 private static int SelectJoinTest(string connectionString)
 {
     var table = new Home("ORMTest");
     return table.Query(@"SELECT h.*
     from Home h
     inner join Province p on h.ProvinceId=p.Id
     where p.Code=@0", 10).Count();
 }
 private static int SelectAllTest(string connectionString)
 {
     var table = new Home("ORMTest");
     return table.All().Count();
 }
        private static int InsertTest(string connectionString)
        {
            var table = new Home("ORMTest");
            var provinces = new Province("ORMTest").All();

            foreach (var home in ORMPerformanceTest.TestData.HomeData.Get100Homes())
            {
                table.Insert(new
                {
                    BuildYear = home.BuildYear,
                    City = home.City,
                    Description = home.Description,
                    ProvinceId = provinces.First(i => i.Code == home.HomeProvince.Code).Id,
                    Price = home.Price,
                    Surface = home.Surface,
                    AddTime = DateTime.Now
                });
            }
            return 100;
        }
 private static int Delete100Test(string connectionString)
 {
     var table = new Home("ORMTest");
     return table.Delete(where: "WHERE BuildYear=@0", args: 2015);
 }
 private static int CountTest(string connectionString)
 {
     var table = new Home("ORMTest");
     long count = table.Count();
     return 1;
 }