Example #1
0
        static void Main(string[] args)
        {
            //for (int i =0; i < 100; i++) TestQueue();
            profiler = new inercya.EntityLite.SqliteProfiler.Profiler(
                AppDomain.CurrentDomain.BaseDirectory,
                ProfileFileFrecuency.Daily,
                true
            );
            ProfilerLite.Current = profiler;
            profiler.StartProfiling();
            using (ds = new NorthwindDataService())
            {
                //SingleTest(50000, InsertSingleItemEntityLite);
                //SequenceTest();
                //QueryByPrimaryKey();
                //ShowSomeProducts();
                //ShowOrderDetails();
                //ShowQuesoCabralesOrders();
                //ShowPagedProducts();
                //ShowLondonAndewFullerSubtree();
                //SearchOrderDetails();
                //ShowProductSales();
                //RaiseProductPrices();
                //InsertUpdateDeleteProduct();
                //RaiseProductPrices2();
                //HandCraftedSql();
                //Localization();
                //WillFail();
                //BuggyShowQuesoCabralesOrders();

                //Pivot();

                ShowAllEmployeesThatSoldSpecifiedProducts();
            }
            profiler.StopProfiling();
            Console.WriteLine("Press enter to exit ...");
            Console.ReadLine();
        }
Example #2
0
 static void InsertSingleItemEntityLite(int i)
 {
     using (var ds = new NorthwindDataService())
     {
         var item = new Entities.Item
         {
             Field1 = "Field 1." + i.ToString(),
             Field2 = "Field 2." + i.ToString(),
             Field3 = "Field 3." + i.ToString(),
             Field4 = "Field 4." + i.ToString()
         };
         ds.ItemRepository.Insert(item);
     }
 }