Querying relationships with LinqtoCRM

Posted on December 13, 2008 | by friism

I’ve just recorded a web cast demontrating joins with LinqtoCRM. The piece de resistance is a join across a many-to-many relationship with the intermediary class generated by CRMMetal:

var res = from u in p.Linq()
	join sr in p.Linq() on u.systemuserid.Value equals sr.systemuserid.Value
	join r in p.Linq() on sr.roleid.Value equals r.roleid.Value
        select new { u.fullname, r.name };

The equivalent example query in the CRM SDK is around forty lines, compared to four for LinqtoCRM. Watch the web cast here.

Comments

Guil on December 19, 2008 at 11:12 am

Good stuff 🙂

Do you plan to add support to custom entities?

Cheers,

friism on December 20, 2008 at 5:25 pm

@Guil, custom entities are supported out of the box, the example just uses a standard entity for common frame of reference.

brenden on May 27, 2009 at 12:53 am

I have an example below of code I have tried to use that is very similar to your demo. It compiles and it authenticates but when the result returns I get a message “Server was unable to process your request”.

Any ideas at all?

CrmAuthenticationToken token = new CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = “QSM”;

CrmService service = new CrmService();

service.Url = “http://qsmcrm:5555/qsm/mscrmservices/2007/CrmService.asmx”;
service.Credentials = new NetworkCredential(“administrator”, “pass@word1”, “crm”);

ICrmService s = new CrmWebService(service);
CrmQueryProvider p = new CrmQueryProvider(s);

var res = from c in p.Linq()
select c.fullname;
foreach (var i in res)
{
Response.Write(i);
}

friism on May 27, 2009 at 12:10 pm

Does the crmqueryprovider work if you don’t use linqtocrm? I.e. can you do a standard query? Otherwise I haven’t a clue.

Brian on February 3, 2010 at 3:32 pm

@brenden
Use the MetadataService, not CrmService
service.Url = “http://qsmcrm:5555/qsm/mscrmservices/2007/MetadataService.asmx”;

Thomas on May 20, 2010 at 9:52 am

Is there a chance to do something like paging?

I have to retrieve all contacts (about 500 000) and import them in a third party system using the webservice provided.

any idea?

admin on May 20, 2010 at 9:59 am

@Thomas, yes — there’s even an example here: http://linqtocrm.codeplex.com/wikipage?title=Querying%20CRM%20with%20Linq&referringTitle=Home

Querying relationships with LinqtoCRM

Comments

Leave a Reply Cancel reply