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