private async Task DoSelectAsync <T>(QTable <T> tb, bool single = false, bool singleOrDefault = false, bool first = false) where T : class
{
if (single)
{
await tb.SingleAsync();
}
if (singleOrDefault)
{
await tb.SingleOrDefaultAsync();
}
if (first)
{
await tb.FirstAsync();
}
await tb.FirstOrDefaultAsync();
await tb.SelectAsync();
await tb.SelectAsync(10);
await tb.SelectAsync(2, 10);
await tb.PageAsync(2, 10);
//Microsoft.Data.Sqlite Bug
//https://github.com/aspnet/Microsoft.Data.Sqlite/issues/435
//await tb.ExecuteDataTableAsync();
}
private async Task DoSelectAsync <T, OutT>(QTable <T> tb, bool single = false, bool singleOrDefault = false, bool first = false) where T : class
{
if (single)
{
await tb.SingleAsync <OutT>();
}
if (singleOrDefault)
{
await tb.SingleOrDefaultAsync <OutT>();
}
if (first)
{
await tb.FirstAsync <OutT>();
}
await tb.FirstOrDefaultAsync <OutT>();
await tb.SelectAsync <OutT>();
await tb.SelectAsync <OutT>(10);
await tb.SelectAsync <OutT>(2, 10);
await tb.PageAsync <OutT>(2, 10);
}
