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

All responses (5)

Answers (0)

Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

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

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.
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

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

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
Suggested answer

Alfredo Aristimuño 135 on at

Like (0)

Report

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

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

Aric Levin - MVP 30,188 Moderator on at

Like (0)

Report

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

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.
Suggested answer

Kishor Kumar 3,710 on at

Like (0)

Report

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

Hi Teja,

Check this,

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