Follow up question to this:
http://stackoverflow.com/questions/1488414/linq-combine-left-join-data
Say I have the following db tables:
Users
-------
UserId (PK)
UserName
Roles
-----
RoleId (PK)
RoleName
UserRoles
---------
UserId (PK)
RoleId (PK)
Users 1-M UserRoles M-1 Roles
Using LinqToSQL, I can return the following set (thanks to response from prior question):
[User1], [Role1, Role2, Role3]
[User2], [Role2, Role3]
[User3], []
The twist is I am using DynamicLinq Library and would like to sort by Roles.
I am using Users.UserRoles.Role.RoleName as the argument but that is not working. Does Dynamic Linq allow 2 level nesting for sorts?