Tuesday, June 2, 2015

Retrive EntityData using QueryExpression Uisng LinkEntities In MS CRM 2011

private void RetrieveEntityData()
        {
            try
            {
                QueryExpression query = new QueryExpression()
                {
                    EntityName = <EntityName>,
                    ColumnSet = new ColumnSet()
                    {
                        Columns = newSystem.Collections.ObjectModel.ObservableCollection<string>()
                    }
                };
                foreach (var item in attributeDetails)
                {
                    query.ColumnSet.Columns.Add(item.SchemaName.ToLower());
                }
                LinkEntity linkentity = new LinkEntity();
                linkentity.LinkFromEntityName = <EntityName>;
                linkentity.LinkToEntityName = relatedEntityName;
                linkentity.LinkFromAttributeName = linkFromAttribute;
         linkentity.LinkToAttributeName = linkToAttribute;
                linkentity.JoinOperator = JoinOperator.Inner;
                linkentity.LinkCriteria = new FilterExpression();
                ConditionExpression condition = new ConditionExpression();
                condition.AttributeName = linkToAttribute;
                condition.Operator = ConditionOperator.Equal;
                condition.Values = new ObservableCollection<object>();
                condition.Values.Add(ReqGuid);
                linkentity.LinkCriteria.Conditions.Add(condition);
                query.LinkEntities = new ObservableCollection<LinkEntity>();
                query.LinkEntities.Add(linkentity);
                // query.PageInfo = new PagingInfo { Count = MaxRecordsToReturn, PageNumber = 1, PagingCookie = null };
                OrganizationRequest request = new OrganizationRequest() { RequestName =“RetrieveMultiple” };
                request[“Query”] = query;
                IOrganizationService service = SilverlightUtility.GetSoapService();
                service.BeginExecute(request, new AsyncCallback(DataGridList_ClickCallback), service);
            }
            catch (SystemException se)
            {
                _syncContext.Send(new SendOrPostCallback(showErrorDetails), se);
            }
        }

No comments:

Post a Comment

How to Deploy your API as a web app or API app

  Before you can call your custom API from a logic app workflow, deploy your API as a web app or API app to Azure App Service. To make your ...