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 returning DataTable (all tables in db are mapped by LS to Entities, but I have the SP computing some values and returning ID and its computed value). How can I handle this? Now I made transient Entity but I don't like it as very unclean. Could I at least map SP returning values to ValueObject? Or any different recommended way (as map values to Dictionary<Entity, decimal>??)?
And - are going to support Scalar Stored Procedures in .NET 3.5 designer? If not, don't mind..
Thanks, Pooik |
|
|
|
|
No, we don't currently provide a way to get the results from a stored procedure into non-entity structures. The transient entity is probably the best way to go, though I agree it is a bit untidy. We do support scalar stored procedures in the designer -- if you drag on a sproc which returns only one column (and that column is not "Id") then we will infer that as a scalar, or you can map one manually by dragging a Scalar Procedure icon from the toolbox. |
|
|
|
