Hi All,
I'm just getting into iBatis, and I'd like to if it can handle multiple
resultsets (.Net 2.0, Sql Server 2005)
For example, I'd have an objects like (pseudo-code):
class Company
{
int Id;
string Name;
List<Classification> Classifications;
}
class Classification
{
int Id;
string Name;
}
And a stored procedure would return 2 resultssets:
SELECT CompanyId, CompanyName FROM Company;
SELECT CompanyId, ClassificationId, ClassificationName FROM
CompanyClassification INNER JOIN Classification ON
CompanyClassification.ClassificationId=Classification .ClassificationId;
Can I some how map the 2nd returned table into "List<Classification>
Classifications" inside my "Company" object?
Cheers,
Miika Mäkinen