通过N：N关系中的多个ID获取实体

debugcn 发表于 Dev

伊万·斯图德尼克（Ivan Studenikin）

给定的实体：团队，用户。两者之间的关系为N：N。

问题：如何查找属于指定团队（具有给定ID列表）的用户。

PS。我发现了如何处理单支球队，却不知道如何处理球队名单？

var team_id = ...
QueryExpression query = new QueryExpression("user");

// setting up relation between teams and users
Relationship rel = new Relationship();
rel.SchemaName = "new_teams_users";

RelationshipQueryCollection relatedEntity = new RelationshipQueryCollection();
relatedEntity.Add(rel, query);

RetrieveRequest request = new RetrieveRequest();
request.RelatedEntitiesQuery = relatedEntity;
request.ColumnSet = new ColumnSet(new string[] {"id"});

request.Target = new EntityReference { Id = team_id, LogicalName = "new_team" };

// Results: List of users by team id.
RetrieveResponse response = (RetrieveResponse)CrmService.Execute(request);

马里奥ZG

建立在相交实体上的QueryExpression将为您提供帮助。例如，我使用产品和竞争对手的N：N关系

QueryExpression qe = new QueryExpression()
{
    EntityName = "competitorproduct",  //this name can be get from N:N rel properties (Relationship form, Relationship Entity Name field)
    ColumnSet = new ColumnSet(true),
};

qe.Criteria.AddCondition(
    "competitorid", 
    ConditionOperator.In, 
    new object[] { "GUID1", "GUID2"});

//Below is optional - if you need some details of entity, add LinkEntity object. This example adds all fields from product entity
LinkEntity lePorduct = new LinkEntity("competitorproduct", "product", "productid", "productid", JoinOperator.Inner);
lePorduct.Columns = new ColumnSet(true);
qe.LinkEntities.Add(lePorduct);

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。