Hello all

I have a question..

Lets say I have two tables Department and Professor

The department table has id(primary key), name
Professor table has id(primarykey), name,address

The Dept_Prof table has deptid and profid.

the corresponding entities are defined in C# and also the mapping is done correctly
class Department
{
int id;
string name;
IDictionary Professors;

}

class Professor
{
int id;
string name;

IDictionary Departments;
}


getProfessorsByDept(int id) is a method to find professors who teach a particular dept.


IDictionary getProfessorsByDept(int id)
{
Department dept = session.Load(
typeof(Department), id );
return dept.Professors;
}

Now how do I modify the above method to sort the results by Name..


Please suggest
Thanks
Sekhar

I don't think it is possible in your specific instance. You _could_ use an orderby attribute in the Department.Professors collection mapping, but I am guessing you only have DepartmentID and ProfessorID in that association table. Ordering by one of those wouldn't give you rhe orderby you are looking for.

Your best bet is to introduce a business method in your DAO, or service layer and use the ICriteria interface.

Alternately, you could implement IComparable on the Professor object and then .Sort() the arraylist, but I've never done that with an IDictionary and I don't know if that is possible.

my .02.

-devon

Hi,
Why don't u try the method Find.
IList List = Session.Find(YourQuery) ;
Here u can use the query that u want to recover the corresponding Professors List.

Regards