You could use QueryWithRowDelegate to do it. Larry
On 8/16/05, Shawn Smiley <[EMAIL PROTECTED]> wrote: > Is it possible to populate an object tree from a > single query? Here is an example of what I'm trying > to do: > > I have an Orders table which is a parent to an > OrderDetails table which references a Products table. > I also have C# classes that mirror the fields in each > table. > > I want to run a single query like: > SELECT O.*, OD.*, P.* > FROM Orders O > INNER JOIN OrderDetails OD ON O.OrderID=OD.OrderID > INNER JOIN Products P ON OD.ProductID=P.ProductID > WHERE O.OrderID=#value# > > And have iBatis generate 1 Order object that contains > an IList of OrderDetail objects with each OrderDetail > Object having a Product object. > > Currently I'm doing this using the select attribute on > the result field in the data map. Unfortunately I'm > already seeing performance problems in my development > environment with just a handful of records in the dev > database. > > So what is the best way to accomplish my goal? Do I > need to write a custom data handler and have that > parse the result set into the individual objects? > > Thanks, > Shawn. > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >
