コード例 #1
0
        public static void BatchB()
        {
            var            list     = Batch.GetList();
            List <Product> products = new List <Product>();

            for (int i = 0; i < list.Count; i++)
            {
                Product product = new Product
                {
                    Id    = list[i],
                    Name  = $"撒旦撒旦撒旦所多多所",
                    Price = 500000
                };
                products.Add(product);
            }

            using (IUnitOfWork unitOfWork = new UnitOfWork("code"))
            {
                try
                {
                    BulkCopyRepository sqlBulkCopyRepository = new BulkCopyRepository(unitOfWork);
                    //sqlBulkCopyRepository.BatchUpdate(products, m => m.With(m.Name, m.Price));

                    sqlBulkCopyRepository.BatchDelete(products);
                    unitOfWork.Complete();
                }
                catch (Exception exception)
                {
                    unitOfWork.Rollback();
                }
            }
        }
コード例 #2
0
        public static void BatchA()
        {
            const int      count    = 10000;
            List <Orders>  orders   = new List <Orders>();
            List <Product> products = new List <Product>();

            for (var i = 0; i < count; i++)
            {
                Product product = new Product
                {
                    Id    = Guid.NewGuid().ToString(),
                    Name  = $"的肯定分拣单{i}",
                    Price = i * 0.8M
                };
                products.Add(product);
                Orders order = new Orders
                {
                    Id        = Guid.NewGuid().ToString(),
                    ProductId = product.Id,
                    Remake    = "是开发大概几点",
                    Status    = 1
                };
                orders.Add(order);
            }

            using (IUnitOfWork unitOfWork = new UnitOfWork("code"))
            {
                using (BulkCopyRepository sqlBulkCopyRepository = new BulkCopyRepository(unitOfWork))
                {
                    try
                    {
                        sqlBulkCopyRepository.BatchInsert(orders);
                        sqlBulkCopyRepository.BatchInsert(products);
                        unitOfWork.Complete();
                    }
                    catch (Exception)
                    {
                        unitOfWork.Rollback();
                    }
                }
            }
        }