Association with stored procedures

[Thomas Skov]

Hey there.

Is there any way to map associations when using
DbManager.SetSpCommand(..).ExecuteList() so I can get a list of
objects with their relations (either one to one or one to many). How
need I structure my stored procedure, and is there any other things I
need to add to make it work? Have tried just adding [Association] to
the List<SubItems> of the main entity class, but it returns null. Any
ideas? Can only find examples that don't use SetCommand/SetSpCommand.

Regards

[Robert Koritnik]

Have you tried using ExecuteResultSet which is used to fetch mutliple
resultsets and also associate them when configured correctly?
http://bltoolkit.net/Doc.ExecuteResultSet.ashx

I've also written a simple MapResultSet builder class that help s a
bit with creating these multi-result array objects:
http://erraticdev.blogspot.com/2011/08/bltoolkit-mapresultset-builder.html