public bool Delete(int id)
{
var query = _dapperQueryBuilder.DeleteQuery(id);
var result = this._mysqlConnection.Execute(query);
_logger.Information("{source} {template} {dbquery} {dbqueryresult}", "repository", typeof(T).Name, query, result);
return(result == 1);
}
public void DeleteQueryWithIdShouldReturnInsertIntoStatement()
{
// Given
var id = 1;
var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();
// When
var query = dapperQueryBuilder.DeleteQuery(id);
// Then
Assert.AreEqual($"update samples set isdeleted=true, isactive=false where id=1", query);
}
public void DeleteQueryWithGuidShouldReturnInsertIntoStatement()
{
// Given
var guid = new Guid("2d62fa93-1be2-4e71-a8df-531b2fc278c3");
var dapperQueryBuilder = new DapperQueryBuilder <SampleEntity>();
// When
var query = dapperQueryBuilder.DeleteQuery(guid);
// Then
Assert.AreEqual($"update samples set isdeleted=true, isactive=false where guid='2d62fa93-1be2-4e71-a8df-531b2fc278c3'", query);
}
