How to retrieve data of another entity from the current entity?

(0) Share

Report

Posted on by Community Member

hi,

i have a requirement.I have 2 entities A and B.When i am working on B entity i want to retrieve the records from A entity.How can i retrieve using C#?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Kishor Kumar 3,710 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Teja,

Check this,

congruentdynamics.blogspot.in/.../retrieve-linked-entity-data-using-query.html

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If there is a relationship between Entity A and Entity B, such that there is a lookup for example in Entity B that has the value of a record in Entity A, you can do a simple QueryByAttribute or QueryExpression.

QueryByAttribute query = new QueryByAttribute();

query.ColumnSet = new ColumnSet(true);

query.EntityName = "new_entityb";

query.AddAttributeValue("new_entityaid", entityAId); // This is a Guid

RetrieveMultipleRequest request = new RetrieveMultipleRequest();

request.Query = query;

RetrieveMultipleResponse response = (RetrieveMultipleResponse)service.Execute(request);

Entity results = (Entity)response.EntityCollection.Entities[0];

try

{

Guid lookupId = new Guid();

lookupId = results.Id;

return lookupId;

}

catch (FaultException<OrganizationServiceFault> ex)

{

throw ex;

}

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Alfredo Aristimuño 135 on at

Like
a
(0)

Report
Copy link

Link copied!

If these entities have a relationship, you can use a quick view form without writing any code technet.microsoft.com/.../dn531145.aspx

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like
a
(0)

Report
Copy link

Link copied!

If you have relationship between these entities, you can use retrieve (as you will have lookup) otherwise you can use retrieve multiple to get record.

You can refer SDK : msdn.microsoft.com/.../gg328198.aspx

Thanks

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You could use QueryExpression in C# to retrieve the records of an entity in Dynamics CRM.

See: arunpotti.wordpress.com/.../retrieve-records-using-query-expression-c-sdk-in-crm/

Hope this helps.

Was this reply helpful? Yes No