public async Task LimitWithTotal() { var limited = new LimitedTable(left, -1, 2); Assert.Equal(2, limited.RowCount); Assert.Equal(3, limited.TableInfo.Columns.Count); var value1 = await limited.GetValueAsync(0, 0); var value2 = await limited.GetValueAsync(0, 1); Assert.Equal(SqlObject.Integer(23), value1); Assert.Equal(SqlObject.Boolean(true), value2); }
public async Task LimitWithOffsetAndTotal() { var limited = new LimitedTable(left, 1, 1); Assert.Equal(1, limited.RowCount); Assert.Equal(3, limited.TableInfo.Columns.Count); var value1 = await limited.GetValueAsync(0, 0); var value2 = await limited.GetValueAsync(0, 1); Assert.Equal(SqlObject.Integer(54), value1); Assert.Equal(SqlObject.Boolean(null), value2); }