linq formulation question using distinct RRS feed

  • Question

  • I have three tables Roles, Permissions, RolePermissions.  The last is many-to-many mapping.

    They have your typical columns like RoleId, PermissionsId, RoleName, PermissionName, etc.

    Given a list of roles, I need to retrieve a distinct list of permissions for the roles specified.

    The entities have Association mapping defined.  I don't want to use join operator if possible.

    Can someone help?

    Tuesday, June 1, 2010 9:14 PM