Microsoft Dynamics CRM (Archived)

How to get N:N relation records in C#

(0) Share

Report

Posted on by Tin

1,562

Hello Team,

I have created a custom entity with N:N relation(User_CustomEntityRelation) with user entity.

Now I have assigned records by look-up filed .But don't know how i can get by using C# code.Please suggest me.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Mahendar Pal 45,095 on at

Like (1)

Report

Hello Rahul,

Check SDK it have sample codes: msdn.microsoft.com/.../gg328446.aspx

rajeevpentyala.wordpress.com/.../retrieve-associated-records-nn-related

Thanks

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (1)

Report

Hi Rahul,

please refer below links,

community.dynamics.com/.../advanced-development-associate-n-n-records-using-c-in-dynamics-crm-2013-2015-which-is-the-best-way

www.corexrm.com/.../creating-many-to-many-records-in-microsoft-dynamics-crm-nn-using-c

lakshmanindian.wordpress.com/.../programmatically-associate-and-disassociate-nn-relationship-records-in-microsoft-dynamics-crm-2011

Hope it may help you !!

Thanks,

Was this reply helpful? Yes No
Tin 1,562 on at

Like (0)

Report

Thanks for the help.

But I am not understanding the logic,how can i get data from entities.

entity 1 ---Config

entity 2 ---Users

N:N Realtion --- new_new_config_systemuser

Please suggest me how i can get data from Config entity,which is on subgrid via n:n realtion.

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Did you check the post and have written any code ?? share your code what you have written and where you have written.

Was this reply helpful? Yes No
Suggested answer

sharma.sandeep82 743 on at

Like (0)

Report

Hi Rahul,

Please go through the below URL.

ssharmacrm.wordpress.com/.../accessing-the-intersection-entity-in-dynamics-crm-plugin

Hope it will help you.

--

Thanks

Sandeep Sharma

Was this reply helpful? Yes No
Tin 1,562 on at

Like (1)

Report

string entity1 = "systemuser";

string entity2 = "slaconfig";

string relationshipEntityName = "new_new_slaconfig_systemuser";

QueryExpression query3 = new QueryExpression(entity1);

query3.ColumnSet = new ColumnSet(true);

LinkEntity linkEntity1 = new LinkEntity(entity1, relationshipEntityName, "systemuserid", "{systemuserid}", JoinOperator.Inner);

LinkEntity linkEntity2 = new LinkEntity(relationshipEntityName, entity2, "new_slaconfigid", "{new_slaconfigid}", JoinOperator.Inner);

linkEntity1.LinkEntities.Add(linkEntity2);

query3.LinkEntities.Add(linkEntity1);

// Add condition to match the Bike name with “Honda”

// linkEntity2.LinkCriteria = new FilterExpression();

// linkEntity2.LinkCriteria.AddCondition(new ConditionExpression("raj_bikename", ConditionOperator.Equal, "Honda"));

EntityCollection collRecords = crmService.RetrieveMultiple(query3);

Please let me know where i am doing wrong

Was this reply helpful? Yes No
Suggested answer

Surmeet Singh 3,075 on at

Like (0)

Report

Hi Rahul,

The best and easiest way is to use fetchXML. You can create your query via advanced find and moreover no such complex programming is required.

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

Hi Rahul,

Please check below links,

social.microsoft.com/.../crm-2011-onpremise-problem-setting-up-lookup-field-in-c-plugin

Thanks

Was this reply helpful? Yes No
Tin 1,562 on at

Like (0)

Report

string entity1 = "systemuser";

string entity2 = "slaconfig";

string relationshipEntityName = "new_new_slaconfig_systemuser";

QueryExpression query3 = new QueryExpression(entity1);

query3.ColumnSet = new ColumnSet(true);

LinkEntity linkEntity1 = new LinkEntity(entity1, relationshipEntityName, "systemuserid", "{systemuserid}", JoinOperator.Inner);

LinkEntity linkEntity2 = new LinkEntity(relationshipEntityName, entity2, "new_slaconfigid", "{new_slaconfigid}", JoinOperator.Inner);

linkEntity1.LinkEntities.Add(linkEntity2);

query3.LinkEntities.Add(linkEntity1);

// Add condition to match the Bike name with “Honda”

// linkEntity2.LinkCriteria = new FilterExpression();

// linkEntity2.LinkCriteria.AddCondition(new ConditionExpression("raj_bikename", ConditionOperator.Equal, "Honda"));

EntityCollection collRecords = crmService.RetrieveMultiple(query3);

above code is working fine but i want to get all columns from both the entity .how can i do.?

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

Hi Rahul,

Can you please follow below links,

stackoverflow.com/.../how-to-get-all-entitys-fields-crm-2011

stackoverflow.com/.../trying-to-get-all-entity-fields-from-a-crm-record-c-sharp

Thanks

Was this reply helpful? Yes No