So say I have the table User->User_Role->Role I want in my business entity to be able to do User.Roles so if I understand this correctly in my User class i should be able to set up the Roles property for user like so.
public Role Roles
Role roles = new Role;
role.QuerySource = \"vUserRoles\";
role.Where.UserId.Value = this.Id;
The problem is the schema for Role does not include the UserId column, the UserId column is grabbed in the view, how will this work?