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