public async Task <IEnumerable <User> > GetAll() { var query = "SELECT * FROM USER ORDER BY NAME"; var filter = new PagedFilterBase() { Page = 1, PageSize = 10 }; var res = await base.QueryPagedAsync <User>(query, filter); return(await base.QueryAsync <User>(query)); }
public void Mssql_Pagination() { IQueryBuilder qBuilder = new MsSqlQueryBuilder(); var expected = "SELECT Id,Name FROM [User] WITH(NOLOCK) WHERE Id=1 ORDER BY Name ASC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY"; var pagination = new PagedFilterBase() { Page = 1, PageSize = 10 }; var actualSql = qBuilder.Select("Id,Name").From("User").Where("Id=1").OrderBy(new OrderBy(true, "Name")).Paginate(pagination).Sql(); Assert.AreEqual(expected, actualSql); }
public void ShouldReturnPagination_When_FilterIsProvided() { IQueryBuilder qBuilder = new PostgreSqlQueryBuilder() { RespectColumnSyntax = false }; var expected = "SELECT id,name FROM [User] WHERE Id=1 ORDER BY name ASC OFFSET (0) LIMIT 10"; var pagination = new PagedFilterBase() { Page = 1, PageSize = 10 }; var actualSql = qBuilder.Select("Id,Name").From("User").Where("Id=1").OrderBy(new OrderBy(true, "Name")).Paginate(pagination).Sql(); Assert.AreEqual(expected, actualSql); }