Get related entities programmatically by 1:N relationship name (CRM 4.0)

(0) Share

Report

Posted on by Community Member

Hi All,

I have entity A and B with thousand records. A has a 1:N relationship named "new_Bs". What is the correct method to get the related Bs for a given A using Crm.Discovery.* APIs? (Not Xrm)

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

st738407 227 on at

Like (0)

Report

In a plugin we use something like the below, where we use LINQ. dds_opportunity_product_line is our child entity (B in your example). Hope this helps.

using (OrganizationServiceContext orgContext = new OrganizationServiceContext(orgService))

{

var oppEF = opportunity.GetAttributeValue<EntityReference>("opportunityid");

var OPLs = orgContext.CreateQuery("dds_opportunity_product_line").Where(p => p.GetAttributeValue<EntityReference>("dds_opportunity_name") ==

oppEF && p.GetAttributeValue<OptionSetValue>("statecode").Value == Constants.OptionSets.EntityState.Active).ToList();

if (OPLs.Count() == 0)

{

return;

}

foreach (var OppProd in OPLs)

{

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Mike,

however it seems that iOrganizationServiceContext requires references to *.Xrm.* which I don't have. I need to rely on CrmService calls.

Was this reply helpful? Yes No
Inogic 709 on at

Like (0)

Report

If you are working on plugin, getting organization service context won’t be problem from you. For standalone application or website you can refer CRM assemblies (“Xrm.SDK”) that will resolve your Xrm issue.

For CRM version earlier than 2016 you can refer SDK assembly Microsoft.Xrm.Client.dll, which will provide you functions to retrieve records using relationship. From 2016 you need to write a function which will retrieve records using Linq.

Was this reply helpful? Yes No