public List <T> List(int page, int pageSize)
{
var query = _dapperQueryBuilder.ListQuery(page, pageSize);
var result = this._mysqlConnection.Query <T>(query);
_logger.Information("{source} {template} {dbquery} {dbqueryresult}", "repository", typeof(T).Name, query, result);
return(result.ToList());
}
public void ListQueryShouldReturnInsertIntoStatement()
{
// Given
var page = 0;
var pageSize = 3;
var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();
// When
var query = dapperQueryBuilder.ListQuery(page, pageSize);
// Then
Assert.AreEqual($"select * from samples order by id limit 3 offset 0", query);
}