C# ClientContext.ExecuteQueryWithExponentialRetry方法代码示例

        /// <summary>
        /// This method will recurse through a tree of Web objects
        /// </summary>
        /// <param name="clientContext"></param>
        /// <param name="web"></param>
        private static void ProcessWebRecursively(ClientContext clientContext, Web web)
        {
            ProcessLibrariesInWeb(clientContext, web);

            var subWebs = web.Webs;
            clientContext.Load(subWebs);
            clientContext.ExecuteQueryWithExponentialRetry(5, 30000);

            foreach (var subWeb in subWebs)
            {
                ProcessWebRecursively(clientContext, subWeb);
            }
        }

        static void Main(string[] args)
        {
            string serverUrl = "<URL>";
            String login = "<USERNAME>";
            String password = "<PASSWORD>";
            string listUrlName = "Shared%20Documents";

            using (var ctx = new ClientContext(serverUrl))
            {
                //Provide acocunt and pwd for connecting to the source
                var passWord = new SecureString();
                foreach (char c in password.ToCharArray()) passWord.AppendChar(c);
                ctx.Credentials = new SharePointOnlineCredentials(login, passWord);

                try
                {
                    int number = 0;
                    // This loop will be executed 1000 times, which will cause throttling to occur
                    while (number < 1000)
                    {
                        // Let's try to create new folder based on Ticks to the given list as an example process
                        var folder = ctx.Site.RootWeb.GetFolderByServerRelativeUrl(listUrlName);
                        ctx.Load(folder);
                        folder = folder.Folders.Add(DateTime.Now.Ticks.ToString());
                        // Extension method for executing query with throttling checks
                        ctx.ExecuteQueryWithExponentialRetry(5, 30000); //5 retries, with a base delay of 10 secs.
                        // Status indication for execution.
                        Console.WriteLine("CSOM request successful.");
                        // For loop handling.
                        number = number + 1;
                    }
                }
                catch (MaximumRetryAttemptedException mex)
                {
                    // Exception handling for the Maximum Retry Attempted
                    Console.WriteLine(mex.Message);
                }
            }
        }

        private static void SetUserProfileDataWithUserContext(Uri sharePointAdminUri, SyncConfiguration configuration, List<GraphApi.IUser> users)
        {
            string tenantAdminLoginName = ConfigurationManager.AppSettings["TenantAdminLogin"];
            string tenantAdminPassword = ConfigurationManager.AppSettings["TenantAdminPassword"];

            using (ClientContext clientContext = new ClientContext(sharePointAdminUri.ToString()))
            {
                //authenticate with SPOCredentials
                SecureString password = new SecureString();
                foreach (char c in tenantAdminPassword.ToCharArray()) password.AppendChar(c);
                clientContext.Credentials = new SharePointOnlineCredentials(tenantAdminLoginName, password);
                clientContext.ExecuteQuery();

                // Get the people manager instance for tenant context
                PeopleManager peopleManager = new PeopleManager(clientContext);

                foreach (GraphApi.User user in users)
                {
                    foreach (Property prop in configuration.Properties)
                    {
                        try
                        {
                            UpdateProperty(peopleManager, user, prop);
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.Message);
                        }
                    }

                    clientContext.ExecuteQueryWithExponentialRetry(10, 30000); //implemented with throttling
                }
            }
        }

        /// <summary>
        ///     Return all document libraries from specified web
        /// </summary>
        /// <param name="clientContext"></param>
        /// <param name="web"></param>
        private static IEnumerable<List> GetAllDocumentLibrariesInWeb(ClientContext clientContext, Web web)
        {
            //Retrieve all lists from specified web
            var lists = web.Lists;
            clientContext.Load(lists);
            //clientContext.ExecuteQuery(); // Commented out in favor of next line and execution throttling
            clientContext.ExecuteQueryWithExponentialRetry(5, 30000); //5 retries, with a base delay of 30 secs.

            //Filter out only document libraries and append to return list collection
            var libraries = new List<List>();
            foreach (var list in lists)
            {
                if (list.BaseType.ToString() == "DocumentLibrary")
                {
                    libraries.Add(list);
                }
            }
            Console.WriteLine("The number of libraries found: " + libraries.Count);
            return libraries;
        }

        /// <summary>
        /// This method executes a CAML query to get all old documents by content type
        /// </summary>
        /// <param name="clientContext"></param>
        /// <param name="documentLibrary"></param>
        /// <param name="contentTypeName"></param>
        /// <param name="retentionPeriod"></param>
        private static void ApplyRetentionPolicy(ClientContext clientContext, List documentLibrary,
            object contentTypeId, int retentionPeriodDays)
        {
            //Calculate validation date. Any document modified before that date is considered old
            var validationDate = DateTime.Now.AddDays(-retentionPeriodDays);
            var camlDate = validationDate.ToString("yyyy-MM-ddTHH:mm:ssZ");

            //Get old documents in the library that are matching requested content type
            if (documentLibrary.ItemCount > 0)
            {
                var camlQuery = new CamlQuery();

                //This CAML query uses Content Type ID with BeginsWith.
                //You can replace with ContentType for CT Display Name, for example
                //<Eq><FieldRef Name='ContentType' /><Value Type='Computed'>{0}</Value></Eq>
                camlQuery.ViewXml = String.Format(
                    @"<View>
                        <Query>
                            <Where><And>
                                <BeginsWith><FieldRef Name='ContentTypeId'/><Value Type='ContentTypeId'>{0}</Value></BeginsWith>
                                <Lt><FieldRef Name='Modified' /><Value Type='DateTime'>{1}</Value></Lt>
                            </And></Where>
                        </Query>
                    </View>", contentTypeId, camlDate);

                var listItems = documentLibrary.GetItems(camlQuery);
                clientContext.Load(listItems,
                    items => items.Include(
                        item => item.Id,
                        item => item.DisplayName,
                        item => item.ContentType));

                //clientContext.ExecuteQuery(); // Commented out in favor of next line and execution throttling
                clientContext.ExecuteQueryWithExponentialRetry(10, 30000); //10 retries, with a base delay of 30 secs.

                foreach (var listItem in listItems)
                {
                    Console.WriteLine("Document '{0}' has been modified earlier than {1}. Retention policy will be applied.", listItem.DisplayName, validationDate);
                    ApplyRetentionActions(clientContext, listItem);
                }

                //perform Retention Actions
                clientContext.ExecuteQueryWithExponentialRetry(10, 30000);
            }
        }