Returning domain object and flag from stored procedure using nhibernate

Question

I’m having some troubles with stored procedures (sp) and nhibernate. I want to map from the returned values of a sp a part to a domain object (already mapped through hbm.xml) and another part to a flag variable. Which is the best way of doing this? without casting objects? As a solution i was trying adding a property value in the domain object named “status” and trying to map that property in the return-property… of sql-query that has the sp.

Answer 1

Could you give some more detail?

I didn't think you could map an object via a stored proc, maybe I am misreading it.

Perhaps you want to make the sp related properties "transient", like your 'status' -so that nhibernate will leave them alone.