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