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