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