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;
}


Now how do I retrive the professors who teach a particular dept.
getProfessorsByDept(int id) is my function.. How do i code this function.
Please suggest

Thanks
Sekhar

You could use HQL like this somewhere in your code (probably ProfessorsRepository)



Let me know if it helps you (and even if it works) and well work from there.

Good luck!

[/quote]

Pseudo-code:



HTH

Hello,

I am using createcriteria. I am not allowed to use HQl.

thanks
sekhar


[/quote]