I try to add a custom property to the result of retrieval stored procedure(resultset).
Could you elaborate more, maybe using a code snippet.
Can i have a entity represent a row in the resultset?
You can fetch a retrieval stored procedure in a DataReader, which you can project to an entityCollection
Please check the manual's section: Using the generated code -> SelfServicing -> Fetching DataReaders and projections