we will provide support for joins in the near future, this feature is important for you and us!
In the mean time you might want consider using an object reference if that is possible for you.
I think in your example the UserRole class could have a User reference and a Role reference.
The query would then be for the moment:
var query1 = (from ur in Os.Extent<ORM.UserRole>()
id = ur.User.UserID,
email = ur.User.Email,
Navn = ur.User.FuldeNavn,
Rolle = ur.Role.Beskrivelse
var ordered = (from q in query1 orderby Navn.ToLower() select q);
the Telerik team