Пример #1
0
        /// <summary>
        /// Customers the model CRUD.
        /// </summary>
        /// <param name="dbcontext3">The dbcontext3.</param>
        /// <param name="i">The i.</param>
        /// <remarks>http://wintersun.cnblogs.com/</remarks>
        private static void CustomerModelCRUD(TestPerformaceDBDB dbcontext3, int i)
        {
            var c1 = new Customer();

            c1.CompanyName = "company";
            c1.CustomerID  = "T" + i;

            //insert
            dbcontext3.Insert.Into <Customer>(c => c.CustomerID, c => c.CompanyName).Values(c1.CustomerID, c1.CompanyName).Execute();
            //update
            dbcontext3.Update <Customer>().Set("CompanyName").EqualTo("test").Where <Customer>(x => x.CustomerID == c1.CustomerID).Execute();
            //delete
            dbcontext3.Delete <Customer>(x => x.CustomerID == c1.CustomerID).Execute();
        }
Пример #2
0
        /// <summary>
        /// Writes the test.
        /// </summary>
        /// <param name="repeatTime">The repeat time.</param>
        /// <returns>The write test.</returns>
        /// <remarks>http://wintersun.cnblogs.com/</remarks>
        public long WriteTest(int repeatTime)
        {
            var dbcontext3 = new TestPerformaceDBDB();

            return(Utility.PerformanceWatch(
                       () =>
            {
                for (int i = 0; i < repeatTime; i++)
                {
                    CustomerModelCRUD(dbcontext3, i);

                    var category = new Category()
                    {
                        CategoryName = "AirLine",
                        Description = "For Air"
                    };

                    category.CategoryID = dbcontext3.Insert.Into <Category>(c => c.CategoryName, c => c.Description).Values(category.CategoryName, category.Description).Execute();

                    dbcontext3.Update <Category>().Set("CategoryName").EqualTo("testupdate").Where <Category>(x => x.CategoryID == category.CategoryID).Execute();

                    var product = new Product()
                    {
                        ProductName = "testproduct1",
                        UnitPrice = 10,
                        QuantityPerUnit = "tt",
                        SupplierID = 3,
                        CategoryID = category.CategoryID
                    };

                    product.ProductID = dbcontext3.Insert.Into <Product>(p => p.ProductName, p => p.UnitPrice, p => p.QuantityPerUnit, p => p.SupplierID)
                                        .Values(product.ProductName, product.UnitPrice, product.QuantityPerUnit, product.SupplierID).Execute();

                    dbcontext3.Update <Product>().Set("ProductName").EqualTo("updateproductname").Where <Product>(p => p.ProductID == product.ProductID).Execute();

                    dbcontext3.Delete <Category>(x => x.CategoryID == category.CategoryID).Execute();

                    dbcontext3.Delete <Product>(x => x.ProductID == product.ProductID).Execute();
                }
            }));
        }