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 ShowAllEmployeesThatSoldSpecifiedProducts()
//{
// var query = ds.EmployeeRepository.ThatSoldAllSpecifiedProductsQuery(Enumerable.Range(1, 6))
// .Fields(EmployeeFields.EmployeeId, EmployeeFields.FirstName, EmployeeFields.LastName)
// .OrderBy(EmployeeFields.FirstName, EmployeeFields.LastName);
// var any = query.Any();
// foreach (var e in query.ToEnumerable())
// {
// Console.WriteLine("{0}: {1} {2}", e.EmployeeId, e.FirstName, e.LastName);
// }
//}
static void InsertMultipleItems(int itemCount)
{
ds.BeginTransaction();
for (int i = 1; i < itemCount; i++)
{
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);
}
ds.Commit();
}