Subsonic Linq guid problem

Question

 The construtor 'Void .ctor(System.Guid, Int32)' is not supported.

this error occured with the following statements:

var Test = from r in db.UserRoles
  join p in db.UserPermissions
    on new { r.userId, r.roleId} equals new { p.userId, p.roleId }
  select r;

userId is a guid roleId is an integer

Answer 1

Right - the constructor for UserRoles looks like it needs a Guid and int - something you're not supplying explicitly. SubSonic has no way of figuring this out for you - one of the many reasons I keep telling people to abstract the membership stuff behind an interface and don't try to use SubSonic to get to it - you're circumventing most of their magic.