Выбор записей Many-To-Many

[Kipetcoff]

Похоже просто не с того конца пошел..все заработало..

QueryExpression query = new QueryExpression();
        query.EntityName = "new_pmrequest";
        query.ColumnSet = new AllColumns();
        //query.ColumnSet = new ColumnSet();
        //query.ColumnSet.AddColumn("new_pmrequestid");

        // Configure the links
        LinkEntity linkEntity1 = new LinkEntity();
        linkEntity1.LinkFromEntityName = "new_pmrequest";
        linkEntity1.LinkFromAttributeName = "new_pmrequestid";
        linkEntity1.LinkToEntityName = "new_new_pmrequest_new_pmsupreqmany";
        linkEntity1.LinkToAttributeName = "new_pmrequestid";

        LinkEntity linkEntity2 = new LinkEntity();
        linkEntity2.LinkFromEntityName = "new_new_pmrequest_new_pmsupreqmany";
        linkEntity2.LinkFromAttributeName = "new_pmsupreqid";
        linkEntity2.LinkToEntityName = "new_pmsupreq";
        linkEntity2.LinkToAttributeName = "new_pmsupreqid";

        // Create the condition to test the contractid
        ConditionExpression condition = new ConditionExpression();
        condition.AttributeName = "new_pmsupreqid";
        condition.Operator = ConditionOperator.Equal;
        condition.Values = new object[] { "16895420-12EC-DF11-BD73-00155D8E4B06" };

        // Add the condition to the link
        linkEntity2.LinkCriteria = new FilterExpression();
        linkEntity2.LinkCriteria.AddCondition(condition);

        // Add the links to the query

        linkEntity1.LinkEntities.Add( linkEntity2 );
        query.LinkEntities.Add( linkEntity1 );

        // Configure the retrieve object

        RetrieveMultipleRequest retrieve = new RetrieveMultipleRequest();
        retrieve.ReturnDynamicEntities = true;
        retrieve.Query = query;

        // Execute retrieve
        RetrieveMultipleResponse retrieved = (RetrieveMultipleResponse)crmService.Execute(retrieve);