How can i avoid per row fetching in to one relationship

Suppose to have a to one relationship, for example between the Movie and Director entities and a window to search Movies, showing for each movie the Director name and surname.

Can i declare in the service object that the finder method for the movie also load data for the director?

I need to obtain that using a single SQL, the framework load objects of type Movie and objects of type Director.

IFetchSpecification has a property called 'Spans' which can be set to a string array of query paths that should be fetched with the main entity. The following code snipped retrieves all movies that have a title starting with A and the corresponding directors.

This will actually result in two SQL statements, one to fetch the movies and a second one to get the corresponding directors. That's still much better than one statement to get the movies and then one statement per movie to get the directors. SQL Server may support non-rectangular result sets but I'm not sure whether that's worth the effort.

Note: This feature has been added for the 1.4 release. As this has not been released at the time of writing you have to work with the latest version from CVS.