views:

10

answers:

0

Hi

I have a link table to link users to qualifications and I am trying to work out if there is any special way subsonic handles this.

I have found this page in the documentation but it doesn't explain what it actually does.

I know I can do a query as such:

QualificationsCollection col = DB.Select().From<Qualification>()  
  .InnerJoin(User_Quals)  
  .InnerJoin(Users)  
  .Where(Users.Columns.Id).IsEqualTo(userid)  
  .ExecuteAsCollection<QualificationsCollection >();

but is there not a way of going

 QualificationsCollection col =User.Qualifications();

Thanks

Bex