Linkentity within queryexpression

(0) Share

Report

Posted on by Community Member

Hey guys..
I found sample code about link entity:

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);

as you can se, there is "aid" and "bid". I still did'nt get on with that "aid" and "bid". Can you tell me what the mean of "aid" and "bid" there.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It has following syntax

LinkEntity EntityB = new LinkEntity(related entity, primary entity, lookup in related entity, primary attribute of primary entity, join);

Thanks

Was this reply helpful? Yes No
Suggested answer

ShahXu 1,515 on at

Like (0)

Report
Copy link

Link copied!

hope it will gives you complete idea.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Does contactid is the primary key from child entity (contact) and customerid is the foreignkey in parent entity (contract) ?

So if in SQL, it would be something like this:

SELECT Contact.a, Contract.b

FROM Contact

INNER JOIN Contract

ON Contact.Contactid = Contract.CustomerID;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hii,

is "aid" is primary key in child entity and foreign key in parent entity ?

Was this reply helpful? Yes No
Suggested answer

ShahXu 1,515 on at

Like (0)

Report
Copy link

Link copied!

yep in my case i wanted to compare contactid with the customerid.

you are pretty much correct.

Was this reply helpful? Yes No
Verified answer

ShahXu 1,515 on at

Like (0)

Report
Copy link

Link copied!

you can compare any two values one from linkFromEntity and LinkToEntity.

it is not necessary that you have to give P.K and F.K

Just like if you want to compare firstname column on both contract and contact then you write firstname column name

Was this reply helpful? Yes No
Verified answer

BackToTheCrm on at

Like (0)

Report
Copy link

Link copied!

Hello Saraswati,

Yes, contactid is the primary key from contact and customerid is the foreignkey in contract

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

ohh i see..

thanks Shahzeb..

now i have another case. Based on sql query i made, i want to retrieve value from Contract. Where the contract entity is child entity. But the type of field that i want to retrieve is lookup field.

for condition clause, i can use this :

.AddCondition("new_gender", ConditionOperator.Equal, 100000000);

so, how about retrieve value from lookup field in child entity ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

ohh i see..

thanks Shahzeb..

now i have another case. Based on sql query i made, i want to retrieve value from Contract. Where the contract entity is child entity. But the type of field that i want to retrieve is lookup field.

for condition clause, i can use this :

addCondition("new_gender", ConditionOperator.Equal, 100000000);

so, how about retrieve value from lookup field in child entity ?

Was this reply helpful? Yes No
Suggested answer

ShahXu 1,515 on at

Like (1)

Report
Copy link

Link copied!

the condtion you are showing here as sample is of optionset not lookup..

lookup condition can be added like this simply

ContractQuery.Criteria.AddCondition("customerid", ConditionOperator.Equal, ContactId);

Was this reply helpful? Yes No