SQL mapping problem

View: New views
1 Messages — Rating Filter:   Alert me  

SQL mapping problem

by Herman Bovens :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,
I have the following problem:

I'm calling a stored procedure and I'm mapping the columns it returns to the fields of a domain object. So far so good.  However, the procedure returns an extra column, which is the same for all rows and is in fact a separate value that does not belong in the domain object.  For performance reasons it is returned by the same procedure.
So I would like to create a class that has a property for this value, and a property which is a list of domain objects (the actual results).  But I don't know how to create a mapping for this, if it is at all possible?
I'm not sure if/how a custom type handler could be used to solve this.

Thanks