I have three main tables I'm working from, an employee, issues and actions table. An issue can have 1 or more associated actions and has an employee initialize the issue. Actions also have an employee who is responsible for each action. What I want to do is bring up all issues that were initialized by a given employee, then bring in all related actions to those issues.

I have no trouble getting the related issues, but I can't seem to bring in the associated actions for each of those issues. If I do a single issue, I can get the actions, but not for a collection of issues. With a single issue, I can go issue.GetMultiActions, but with a collection of issues, I can't do that, which is probably obvious to those more familiar with LLBLGen than me. How can I get only the actions related to my collection of issues?

I'm using ASP.NET, so I want to limit postbacks as much as possible. The purpose of getting this information is so users can view the issues they created (with their related actions) in a master-detail format for adding/editing. I hope I've provided enough information.

OK, I guess I didn't even need to do that. When I load the issues and bind them to the infragistics datagrid, the actions are there. Cool.

You should also consider a prefetch path, it can help reduce the amount of queries executed when the user browses through the grid. Though it depends on if the user will open a lot of related, deep trees or just one or two.