Get related entities from Many to many relation CRM 2011

I had a request to obtain all related entities from N:N relation for a specific entity in this relation. There might be other ways to achieve this but this method I used and it worked for me, so I thought to share it with you in case somebody else will need it.

This is the function that returns the a collection of entities for a specific entity from this relation.


 /// <summary>
        /// get entities from many to many relation
        /// </summary>
        /// <param name="entityToRetrieve">the entity name that we want to retrieve</param>
        /// <param name="relationName">relation name</param>
        /// <param name="targetEntity">entity name</param>
        /// <param name="service"></param>
        /// <returns>collection of entities</returns>
        public static DataCollection<Entity> GetRelatedEntitDataFromManyToManyRelation(string entityToRetrieve, string[] columnsToRetieve, string relationName, EntityReference targetEntity, IOrganizationService service)
        {
            DataCollection<Entity> result = null;
         
                QueryExpression query = new QueryExpression();
                query.EntityName = entityToRetrieve;
                query.ColumnSet = new ColumnSet(columnsToRetieve);
                Relationship relationship = new Relationship();

                relationship.SchemaName = relationName;

                RelationshipQueryCollection relatedEntity = new RelationshipQueryCollection();
                relatedEntity.Add(relationship, query);
                RetrieveRequest request = new RetrieveRequest();
                request.RelatedEntitiesQuery = relatedEntity;
                request.ColumnSet = new ColumnSet(targetEntity.LogicalName + "id");
                request.Target = targetEntity;
                RetrieveResponse response = (RetrieveResponse)service.Execute(request);


                if (((DataCollection<Relationship, EntityCollection>)(((RelatedEntityCollection)(response.Entity.RelatedEntities)))).Contains(new Relationship(relationName)) && ((DataCollection<Relationship, EntityCollection>)(((RelatedEntityCollection)(response.Entity.RelatedEntities))))[new Relationship(relationName)].Entities.Count > 0)
                {
                    result = ((DataCollection<Relationship, EntityCollection>)(((RelatedEntityCollection)(response.Entity.RelatedEntities))))[new Relationship(relationName)].Entities;
                }
         
            return result;
        }


You can call this function is like this:
var relatedAccountsForTarget = GetRelatedEntitDataFromManyToManyRelation("account", new string[]{ "accountid" }, "Type here relationName", targetEntity.ToEntityReference(), utils.Service);