public List <InvoiceItemEntity> Execute() { var command = new NpgsqlCommand(Sql, _dataSource.DbConnection); var resultSet = command.ExecuteReader(); var result = _rowMapper.FromResultSet(resultSet); _dataSource.CloseDbConnection(); return(result); }
public InvoiceItemEntity Execute() { var command = new NpgsqlCommand(Sql, _dataSource.DbConnection); command.Parameters.AddWithValue("Id", (long)_queryParamId); command.Prepare(); var resultSet = command.ExecuteReader(); var result = _rowMapper.FromResultSet(resultSet).FirstOrDefault(); _dataSource.CloseDbConnection(); return(result); }