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