crm2011查询表的关联关系

最新推荐文章于 2021-12-06 15:01:01 发布

原创最新推荐文章于 2021-12-06 15:01:01 发布 · 828 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#crm2011查询表的关联关系

CRM 专栏收录该内容

173 篇文章

订阅专栏

本博客展示了如何使用CRM服务查询关联关系，包括一对多、多对多和多对一关系的详细解析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    using System;
    using Microsoft.Xrm.Sdk;
    using Microsoft.Xrm.Sdk.Messages;
    using Microsoft.Xrm.Sdk.Metadata;

    /// <summary>
    /// 查询CRM关联关系
    /// </summary>
    public class RelationshipHelper
    {
        public void Retrieve(IOrganizationService service)
        {
            //构造Request对象
            RetrieveAllEntitiesRequest request = new RetrieveAllEntitiesRequest();
            request.EntityFilters = Microsoft.Xrm.Sdk.Metadata.EntityFilters.Relationships;
            //是否已经发布
            request.RetrieveAsIfPublished = true;

RetrieveAllEntitiesResponse response = (RetrieveAllEntitiesResponse)service.Execute(request);

            if (response != null && response.EntityMetadata.Length > 0)
            {
                foreach (EntityMetadata currentEntity in response.EntityMetadata)
                {
                    //对应实体的名称
                    System.Console.WriteLine("Entity,LogicalName: " + currentEntity.LogicalName);

                    //遍历一对多关系
                    foreach (OneToManyRelationshipMetadata currentRelationship in currentEntity.OneToManyRelationships)
                    {
                        //关系的架构名称
                        System.Console.WriteLine("SchemaName: " + currentRelationship.SchemaName);
                        //引用的实体
                        System.Console.WriteLine("ReferencingEntity: " + currentRelationship.ReferencingEntity);
                        //引用实体的属性
                        System.Console.WriteLine("ReferencingAttribute: " + currentRelationship.ReferencingAttribute);
                        //被引用的实体
                        System.Console.WriteLine("ReferencedEntity: " + currentRelationship.ReferencedEntity);
                        //被引用实体的属性
                        System.Console.WriteLine("ReferencedAttribute: " + currentRelationship.ReferencedAttribute);

}

                    //遍历多对多关系
                    foreach (ManyToManyRelationshipMetadata currentRelationship in currentEntity.ManyToManyRelationships)
                    {
                        //关系的架构名称
                        System.Console.WriteLine("SchemaName: " + currentRelationship.SchemaName);

                        //实体1名称
                        System.Console.WriteLine("Entity1LogicalName: " + currentRelationship.Entity1LogicalName);
                        //实体1的属性
                        System.Console.WriteLine("Entity1IntersectAttribute: " + currentRelationship.Entity1IntersectAttribute);
                        //实体2名称
                        System.Console.WriteLine("Entity2LogicalName: " + currentRelationship.Entity2LogicalName);
                        //实体2的属性
                        System.Console.WriteLine("Entity2IntersectAttribute: " + currentRelationship.Entity2IntersectAttribute);
                    }

                    //遍历多对一关系
                    foreach (OneToManyRelationshipMetadata currentRelationship in currentEntity.ManyToOneRelationships)
                    {
                        //关系的架构名称
                        System.Console.WriteLine("SchemaName: " + currentRelationship.SchemaName);
                        //引用的实体
                        System.Console.WriteLine("ReferencingEntity: " + currentRelationship.ReferencingEntity);
                        //引用实体的属性
                        System.Console.WriteLine("ReferencingAttribute: " + currentRelationship.ReferencingAttribute);
                        //被引用的实体
                        System.Console.WriteLine("ReferencedEntity: " + currentRelationship.ReferencedEntity);
                        //被引用实体的属性
                        System.Console.WriteLine("ReferencedAttribute: " + currentRelationship.ReferencedAttribute);

                    }
                }
            }
        }
    }