I have a service operation that queries multiple entities in a data source using joins. However, I can't seem to get to the joined entity, either when browsing the data service in IE, or when consuming the data service in the silverlight client code.
With this code in the data service operation method:
var query = from o in crmOnline.opportunityopportunities
join su in crmOnline.systemusers
on o.ownerid.Value equals su.systemuserid
Should I not be able to view the data service in a browser and see the systemusers like this (the service operation takes two arguments, userid and org):
or to consume it in the client like this
foreach (opportunity opp in response)
string name = opp.name;
string ownername = opp.opportunity_owning_user.fullname;
In either scenario, I'm not having success. When browsing the URL posted above, I get an http 400 "webpage cannot be found" error. I get a null reference exception in the client. Any help would be greatly appreciated!
View Complete Post