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