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