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