crm2011查询表的关联关系

    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);

                    }
                }
            }
        }
    }