Microsoft Dynamics CRM (Archived)

LinkEntities in C# add many relationships

(0) Share

Report

Posted on by 00f137054c6340ccb3e...

225

Hi i want to create a QueryExpression similar to this.

select
a.a,
a.b,
b.a,
c.a,
c.b

from a

inner join b on a.ida=b.ida
inner join c on b.idb=c.idb

My problema is the addlink how to manage this, b entity to c entity, when i make the addlink is a entity to b entity or u can make a enitity to c entity this way i can manage but no b to c.

Thanks in advance,

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

ScottDurow 21 on at

Like (4)

Report

Hi JP,

The LinkEntity allows adding further sub links so you can join from b to c (msdn.microsoft.com/.../microsoft.xrm.sdk.query.linkentity.addlink.aspx)

In fetch xml it would be:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">

<entity name="a">

<attribute name="a" />

<attribute name="b" />

<link-entity name="b" from="bid" to="bid">

<attribute name="a" /

<link-entity name="c" from="cid" to="cid">

<attribute name="a" />

<attribute name="b" />

</link-entity>

</link-entity>

</entity>

</fetch>

So when you add the link from a to b, add another LinkEntity using AddLink from b to c.

Hope this helps,

Scott

Was this reply helpful? Yes No
00f137054c6340ccb3e... 225 on at

Like (2)

Report

Thanks Scott,

Indeed that is the way. my two cents. fully working.

QueryExpression SrchQry = new QueryExpression();

SrchQry.EntityName = A.LogicalName;

SrchQry.ColumnSet = new ColumnSet("a", "b", "c");

SrchQry.Criteria.AddCondition("country", ConditionOperator.Equal, new string[] { strcodigo });

LinkEntity EntityB = new LinkEntity(A.LogicalName, B.LogicalName, "aid", "aid", JoinOperator.Inner);

EntityB.Columns = new ColumnSet("a", "b");

EntityB.EntityAlias = "Entb";

LinkEntity EntityC = new LinkEntity(B.LogicalName, C.LogicalName, "bid", "bid", JoinOperator.Inner);

EntityC.Columns = new ColumnSet("a", "b");

EntityC.EntityAlias = "Entc";

SrchQry.LinkEntities.Add(EntityB);

EntityB.LinkEntities.Add(EntityC);

//Retrive

EntityCollection RespuestaBusquedaQry = _service.RetrieveMultiple(SrchQry);

Greetings,

JP

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi juan... i wanna ask what is the "aid" there ?

LinkEntity EntityB = new LinkEntity(A.LogicalName, B.LogicalName, "aid", "aid", JoinOperator.Inner);

from what i know, when we want to use linkentity. There are four parameter we need to include inside the linkentity. there are linkfromentityname, linktoentityname, linkfromattributename and linktoattributename.

iam able to understand the first two parameter. but i still did'nt get it for the last two parameter. Are linkfromattribute is primary key from the child entity and linktoattribute is foreign key in parent entity.

can you give me simple explanation ?

Was this reply helpful? Yes No
00f137054c6340ccb3e... 225 on at

Like (0)

Report

Hi Saraswati,

I use five parameters because u can put the type of join (inner, left ...), and yes is the queryexpresion(SrchQry) to linktoentity, that would be like this, new LinkEntity(SrchQry.LogicalName, B.LogicalName, "SrchQrylogicalid", "blogicalid", JoinOperator.Inner);

Happy coding, greetings.

JP

Was this reply helpful? Yes No

Community site session details

LinkEntities in C# add many relationships

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

LinkEntities in C# add many relationships

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates