public T Read(int id)
        {
            var query  = _dapperQueryBuilder.ReadQuery(id);
            var result = this._mysqlConnection.QueryFirstOrDefault <T>(query);

            _logger.Information("{source} {template} {dbquery} {dbqueryresult}", "repository", typeof(T).Name, query, result);
            return(result);
        }
        public void ReadQueryWithGuidShouldReturnInsertIntoStatement()
        {
            // Given
            var guid = new Guid("2d62fa93-1be2-4e71-a8df-531b2fc278c3");
            var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();

            // When
            var query = dapperQueryBuilder.ReadQuery(guid);

            // Then
            Assert.AreEqual($"select * from samples where guid='2d62fa93-1be2-4e71-a8df-531b2fc278c3'", query);
        }
        public void ReadQueryWithIdShouldReturnInsertIntoStatement()
        {
            // Given
            var id = 1;
            var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();

            // When
            var query = dapperQueryBuilder.ReadQuery(id);

            // Then
            Assert.AreEqual($"select * from samples where id=1", query);
        }