views:

134

answers:

0

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?