C# XrmServiceContext.Execute方法代码示例

        public static void SavedQueries(XrmServiceContext svcContext)
        {
            QueryExpression mySavedQuery = new QueryExpression
            {
                ColumnSet = new ColumnSet("savedqueryid", "name", "querytype", "isdefault", "returnedtypecode", "isquickfindquery"),
                EntityName = SavedQuery.EntityLogicalName,
                Criteria = new FilterExpression
                {
                    Conditions =
                    {
                        new ConditionExpression
                        {
                            AttributeName = "querytype",
                            Operator = ConditionOperator.Equal,
                            Values = {0}
                        },
                        new ConditionExpression
                        {
                            AttributeName = "returnedtypecode",
                            Operator = ConditionOperator.Equal,
                            Values = {SalesOrder.EntityTypeCode}
                        }
                    }
                }
            };
            RetrieveMultipleRequest retrieveSavedQueriesRequest = new RetrieveMultipleRequest { Query = mySavedQuery };

            RetrieveMultipleResponse retrieveSavedQueriesResponse = (RetrieveMultipleResponse)svcContext.Execute(retrieveSavedQueriesRequest);

            DataCollection<Entity> savedQueries = retrieveSavedQueriesResponse.EntityCollection.Entities;

            using (StreamWriter sw = new StreamWriter(crmPath + "SavedQueries.txt"))
            {
                //Display the Retrieved views
                String oo = "Open Orders (Support)";
                SavedQuery sq = new SavedQuery();
                sw.WriteLine("rsq.SavedQueryId;rsq.Name;rsq.QueryType;rsq.IsDefault;rsq.ReturnedTypeCode;rsq.IsQuickFindQuery");
                foreach (Entity ent in savedQueries)
                {
                    SavedQuery rsq = (SavedQuery)ent;
                    sw.WriteLine("{0};{1};{2};{3};{4};{5}", rsq.SavedQueryId, rsq.Name, rsq.QueryType, rsq.IsDefault, rsq.ReturnedTypeCode, rsq.IsQuickFindQuery);
                    if (rsq.Name.Equals(oo))
                        sq = rsq;
                }
                sw.WriteLine("*****************");
                sw.WriteLine("FetchXml: " + sq.FetchXml);
                sw.WriteLine("ColumnSetXml: " + sq.ColumnSetXml);
                //sw.WriteLine("CreatedBy: " + sq.CreatedBy.Name);
                sw.WriteLine("Description: " + sq.Description);
                sw.WriteLine("QueryAPI: " + sq.QueryAPI);
                sw.WriteLine("ReturnedTypeCode: " + sq.ReturnedTypeCode);

                ExecuteByIdSavedQueryRequest executeSavedQueryRequest = new ExecuteByIdSavedQueryRequest()
                {
                    EntityId = sq.Id
                };

                // Execute the request
                sw.WriteLine("  Executing Saved Query");
                ExecuteByIdSavedQueryResponse executeSavedQueryResponse =
                    (ExecuteByIdSavedQueryResponse)svcContext.Execute(executeSavedQueryRequest);

                // Check results
                if (String.IsNullOrEmpty(executeSavedQueryResponse.String))
                    throw new Exception("Saved Query did not return any results");

                sw.WriteLine(executeSavedQueryResponse.String);

            }
        }

        /// <summary>
        /// This method first creates a series of Accounts to query over, a user query 
        /// that retrieves the names of all Accounts with a name of 'Coho Winery' and 
        /// a system query that retrieves all Account names. Then it validates the system 
        /// query, executes the system query and displays the results, and finally 
        /// executes the user query and displays the results.
        /// </summary>
        /// <param name="serverConfig">Contains server connection information.</param>
        /// <param name="promptforDelete">When True, the user will be prompted to delete all
        /// created entities.</param>
        public void Run(XrmServiceContext _serviceProxy, bool promptforDelete)
        {
            try
            {
                // Connect to the Organization service.
                // The using statement assures that the service proxy will be properly disposed.
                using (_serviceProxy)
                {
                    // This statement is required to enable early-bound type support.
                    ///_serviceProxy.EnableProxyTypes();

                    CreateRequiredRecords();

                    #region Validate saved query

                    // Create the request
                    ValidateSavedQueryRequest validateRequest = new ValidateSavedQueryRequest()
                    {
                        FetchXml = _savedQuery.FetchXml,
                        QueryType = _savedQuery.QueryType.Value
                    };

                    // Send the request
                    Console.WriteLine("  Validating Saved Query");
                    try
                    {
                        // executing the request will throw an exception if the fetch xml is invalid
                        var validateResponse = (ValidateSavedQueryResponse)_serviceProxy.Execute(validateRequest);
                        Console.WriteLine("  Saved Query validated successfully");
                    }
                    catch (Exception)
                    {
                        Console.WriteLine("  Invalid Saved Query");
                        throw;
                    }

                    #endregion

                    #region Execute saved query

                    // Create the request
                    ExecuteByIdSavedQueryRequest executeSavedQueryRequest = new ExecuteByIdSavedQueryRequest()
                    {
                        EntityId = _savedQuery.Id
                    };

                    // Execute the request
                    Console.WriteLine("  Executing Saved Query");
                    ExecuteByIdSavedQueryResponse executeSavedQueryResponse =
                        (ExecuteByIdSavedQueryResponse)_serviceProxy.Execute(executeSavedQueryRequest);

                    // Check results
                    if (String.IsNullOrEmpty(executeSavedQueryResponse.String))
                        throw new Exception("Saved Query did not return any results");

                    PrintResults(executeSavedQueryResponse.String);
                    #endregion

                    #region Execute user query

                    // Create the request
                    ExecuteByIdUserQueryRequest executeUserQuery = new ExecuteByIdUserQueryRequest()
                    {
                        EntityId = _userQuery.ToEntityReference()
                    };

                    // Send the request
                    Console.WriteLine("  Executing User Query");
                    ExecuteByIdUserQueryResponse executeUserQueryResponse =
                        (ExecuteByIdUserQueryResponse)_serviceProxy.Execute(executeUserQuery);
                    if (String.IsNullOrEmpty(executeUserQueryResponse.String))
                        throw new Exception("User Query did not return any results");

                    // validate results
                    PrintResults(executeUserQueryResponse.String);

                    #endregion

                    DeleteRequiredRecords(promptforDelete);
                }
            }

            // Catch any service fault exceptions that Microsoft Dynamics CRM throws.
            catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault>)
            {
                // You can handle an exception here or pass it back to the calling method.
                throw;
            }
        }

 private static void getInfoByGUID(XrmServiceContext svcContext)
 {
     var request = new ExecuteByIdSavedQueryRequest
     {
         EntityId = new Guid("00000000-0000-0000-00AA-000010001002")//Account
         //EntityId =   new Guid("B1605B89-3BFE-E411-B185-6C3BE5A6CB54")
         //EntityId = new Guid("b053a39a-041a-4356-acef-ddf00182762b")//&id=%7bB1605B89-3BFE-E411-B185-6C3BE5A6CB54%7d&pagetype
     };
     var response = (ExecuteByIdSavedQueryResponse)svcContext.Execute(request);
     string resultset = response.String;
 }