Take the 2-minute tour ×

How to create and delete data from entity relationship many-to-many in crm 2011?


QueryExpression qry = new QueryExpression();
qry.EntityName = "entity1_entity2";
qry.ColumnSet = new ColumnSet(true);

var re = crmservice.RetrieveMultiple(qry).Entities;

crmservice.Delete("entity1_entity2", re[0].Id);

FaultException: The 'Delete' method does not support entities of type 'entity1_entity2'.

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

In order to link two records via a N:N relationship, you have to use the Associate/Disassociate request or the corresponding methods of the service proxy.

This will create/delete the corresponding record of the entity1_entity2 entity.

share|improve this answer
add comment
using Microsoft.Crm.Sdk.Messages;
// get the crm service
AssociateEntitiesRequest fooToBar = new AssociateEntitiesRequest
    Moniker1 = foo,                // foo is an entity reference
    Moniker2 = bar,                // bar is an entity reference
    RelationshipName = "foo_bar",  // name of the relationship

service.Execute(fooToBar)          // relates foo and bar

Here's a blog post: http://charithrajapaksha.blogspot.com/2011/08/creating-many-to-many-records-in-crm.html

share|improve this answer
add comment

In N:N Relationships the records should be associated and disassociated. you can't create and delete records in N:N Relationship. you can use AssociateRequest, DisassociateRequest classes or you can use Associate, Disassociate Messages in Plugin Registration tool.

share|improve this answer
add comment

Your Answer


