score:6

Accepted answer

instead of users.id, try users.systemuserid. similarly, instead of teams.id, try teams.teamid.

as for the reason why this works, i'm not aware of any documentation that states this, but because entities in the generated early-binding file inherit from entity, they necessarily have an id property. however, because the early-bound organizationservicecontext maps entity attributes directly to the crm database, the tables of which don't contain an id column, using the id attribute with the linq provider won't work, so you'd have to use the actual database/schema names.


Related Query

More Query from same tag