Hi,

Recently we wrote a plugin that was using RetrieveResponse class to get the information of an n – n relationship using Relationship class.

The issue that we faced over here is that the Entity property of RetrieveResponse is read only, we cannot set it. The option was to write the wrapper class over it and use the same wrapper class in the code and the unit test.

/// <summary>
 /// Wrapper class for retrieve response
 /// </summary>
 [DataContract(Namespace = "http://schemas.microsoft.com/xrm/2011/Contracts")]
 public class RetrieveResponseWrapper : OrganizationResponse
 {
 /// <summary>
 /// The _entity
 /// </summary>
 private Entity entity;

/// <summary>
 /// Initializes a new instance of the <see cref="RetrieveResponseWrapper"/> class.
 /// </summary>
 /// <param name="response">The response.</param>
 public RetrieveResponseWrapper(OrganizationResponse response)
 {
 try
 {
 this.entity = ((RetrieveResponseWrapper)response).Entity;
 }
 catch
 {
 this.entity = ((RetrieveResponse)response).Entity;
 }
 }

/// <summary>
 /// Gets or sets the entity.
 /// </summary>
 /// <value>
 /// The entity.
 /// </value>
 public Entity Entity
 {
 get
 {
 return this.entity;
 }

set
 {
 this.entity = value;
 }
 }
 }

 

Check out this post for more details
http://www.alexanderdevelopment.net/post/2013/01/13/How-to-unit-test-C-Dynamics-CRM-interface-code-part-III

 Hope it helps.

Suppose we need to query a n:n relationship and get details of both the entity records involved.

For this we can make use of Relationship and RelationshipQueryCollection class,

Suppose I have an entity named A  and it has n to n relationship with B  Entity.

This I how we can get the details all the A records associated with a particular entity B record.

i.e. Name of all the A records associated with a particular B entity record along with the  name of the B entity record.

</pre>
private void GetManytoManyRelationShipDetails(IOrganizationService _service, Guid entityBGuid)
 {
 // get offences records' name
 QueryExpression query = new QueryExpression("EntityA");
 ColumnSet cols = new ColumnSet();
 cols.AddColumn("EntityANameToBeRetreived");
 query.ColumnSet = cols;

// Relationship Name
 Relationship relationship = new Relationship("EntityA_EntityBRelationshipName");
 RelationshipQueryCollection relationshipColl = new RelationshipQueryCollection();
 relationshipColl.Add(relationship, query);

// get the legal issue record's name
 RetrieveRequest request = new RetrieveRequest();
 request.RelatedEntitiesQuery = relationshipColl;
 request.Target = new EntityReference("EntityB", entityBGuid);
 request.ColumnSet = new ColumnSet("EntityBNameToBeRetreived");
 RetrieveResponse response = (RetrieveResponse)_service.Execute(request);

string entityAName = string.Empty;

foreach (Entity entity in response.Entity.RelatedEntities[relationship].Entities)
 {
 entityAName += entity.Attributes["EntityAName"].ToString();
 }
 }

Hope it helps.