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));
}
