This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I have a stored procedure which returns data built up from 2 memory tables. I have created a transient entity for both tables that are being returned and created a one-to-many association between the 2 tables. I get an exception about no having an identity key. First question is, can I return multiple results from an SProc and have the results mapped to a transient entity? If not, whats the best solution for handling this scenario using LS5. Cheers |
|
|
No Im afraid not, we only handle a single result set with procs so for multiple results you will need to make multiple proc calls, one for each type of entity you are loading. In terms of the lack of an identity key are you returning an Id column (or columns in the case of a composite key) from your proc?
|
|