How to get the related entities by code?

(0) Share

Report

Posted on by Juanmaprog

Hello,
I am trying to get the collection of related entities and I am not succeeding.

My code:

using (var _service = new OrganizationServiceProxy(new Uri(url), null, clientCredentials, null))
{
    _service.EnableProxyTypes();

    Guid _accountId = new Guid("e7385903-d01f-ea11-a810-000d3a654128");
    Guid _contactId = new Guid("ce30c7ae-cf1f-ea11-a810-000d3a654128");

    var filter = new FilterExpression();
    filter.AddCondition("accountid", ConditionOperator.Equal, _accountId);

    var account = RetrieveFirstOrDefault(filter);

    //How to fill in the account contacts
    //account.ait_account_contact

    return account;
}

I will appreciate any help, thank you.

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Steven RH JIANG Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So may I suppose you want to retrieve the account list whose contact field is equal to a specified contact record?

You need to use link entity. Please refer to https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/279405/how-to-use-filter-on-link-entity/797943

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi Juan,

There are two ways you can get the related entities records.

1. By Following below links:

Blog of Inogic: “Retrieve related entity records along wih the Primary entity using Retrieve Method | Microsoft Dynamics 365 CRM Tips and Tricks (inogic.com)”

Other Community post answer: “QueryExpression for all Related Entities - Microsoft Dynamics CRM Forum Community Forum"

2. 2. Other way is using fetchxml:

XRM toolbox -> Fetchxml builder.

Right-click on fetch -> Add/Select parent entity -> Right click on Entity -> Add -> link-entity.

Select Relationship with your link entity then fetchxml builder will auto-populate other fields.

Using the generated fetchxml user can the linked entity records. On explore of this tool, you will find some more useful details.

Was this reply helpful? Yes No