static async Task SelectIntoAsyncTest() { ds.BeginTransaction(); var tableName = "##OrderDetails" + Guid.NewGuid().ToString("N"); var createdRowCount = ds.OrderDetailRepository.Query(Projection.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.Equals, 9) .SelectIntoAsync(tableName); var q2 = new TableOrViewQueryLite <OrderDetail>(tableName, ds); var orderDetailsInTempTable = await q2.ToListAsync(); ds.Commit(); }
static void InsertIntoTest() { var q = ds.OrderDetailRepository.Query(Projection.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.In, Enumerable.Empty <int>()); var tableName = "##OrderDetails" + Guid.NewGuid().ToString("N"); var count = q.SelectInto(tableName); var q2 = new TableOrViewQueryLite <OrderDetail>(tableName, ds); var orderDetails = q2.ToList(); var q3 = ds.OrderDetailRepository.Query(Projection.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.Equals, 9); var count2 = q3.InsertInto(tableName, "OrderID", "ProductID", "UnitPrice", "Quantity", "Discount"); orderDetails = q2.ToList(); }
static async Task InsertIntoAsyncTest() { var tableName = "##OrderDetails" + Guid.NewGuid().ToString("N"); var count = await ds.OrderDetailRepository.Query(Projection.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.In, Enumerable.Empty <int>()) .SelectIntoAsync(tableName); var orderDetails = await new TableOrViewQueryLite <OrderDetail>(tableName, ds).ToListAsync(); var count2 = ds.OrderDetailRepository.Query(Projection.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.Equals, 9) .InsertIntoAsync <OrderDetail>(tableName, nameof(OrderDetail.OrderId), nameof(OrderDetail.ProductId), nameof(OrderDetail.UnitPrice), nameof(OrderDetail.Quantity), nameof(OrderDetail.Discount) ); var subquery = new TableOrViewQueryLite <OrderDetail>(tableName, ds) .Fields(FieldsOption.None, nameof(OrderDetail.OrderId)); var orders = await ds.OrderRepository.Query(OrderProjections.Extended) .Where(nameof(Order.OrderId), OperatorLite.In, subquery) .ToListAsync(); var count3 = await ds.OrderDetailRepository .Query(OrderDetailProjections.BaseTable) .Where(nameof(OrderDetail.ProductId), OperatorLite.Equals, 9) .OrderBy(nameof(OrderDetail.OrderId)) .InsertIntoBaseTableAsync <OrderDetailCopy>( nameof(OrderDetailCopy.OrderId), nameof(OrderDetailCopy.ProductId), nameof(OrderDetailCopy.UnitPrice), nameof(OrderDetailCopy.Quantity), nameof(OrderDetailCopy.Discount)); var count4 = await ds.OrderDetailCopyRepository .Query(OrderDetailCopyProjections.BaseTable) .Where(nameof(OrderDetailCopy.ProductId), OperatorLite.Equals, 9) .OrderBy(nameof(OrderDetailCopy.OrderId)) .InsertIntoBaseTableAsync( nameof(OrderDetailCopy.OrderId), nameof(OrderDetailCopy.ProductId), nameof(OrderDetailCopy.UnitPrice), nameof(OrderDetailCopy.Quantity), nameof(OrderDetailCopy.Discount)); }