Code Snippet: Programmatically Request a Cache Refresh on the Client

SharePoint 2010

Last modified: May 13, 2010

Applies to: SharePoint Server 2010

In this article
Description
Prerequisites
To use this example

The following code example shows how to programmatically do a cache refresh from a client application. When run, this code starts the BCSSync service if it is not already running and requests a refresh in the BDC client cache.

  • Microsoft SharePoint Server 2010 or Microsoft SharePoint Foundation 2010 installed on the server

  • Microsoft Office Professional Plus 2010 and Microsoft .NET Framework 3.5 installed on the client computer

  • Microsoft Visual Studio

  • At least one subscription in the Business Connectivity Services Client Cache

  1. Start Visual Studio on the client computer. and then create a new C# Microsoft Office application add-in project. Select .NET Framework 3.5 when you create the project.

  2. From the View menu, select Property Pages to bring up the project properties.

  3. On the Build tab, for the Platform target, select Any CPU.

  4. Close the project properties window.

  5. In Solution Explorer, under References, remove all project references except for System and System.Core.

  6. Add the following references to the project:

    1. Microsoft.Office.BusinessApplications.Runtime

    2. Microsoft.BusinessData

  7. Replace the existing using statements with the following statements:

    using System;
    using Microsoft.BusinessData.Offlining;
    using Microsoft.Office.BusinessData.Offlining;
    
    
  8. Replace the code in the add-in’s startup event with the code listed at the end of this procedure.

  9. Replace the placeholder values of <entityNamespace>, <entityName>, <viewName>, and <subscriptionName> with valid values.

  10. Save the project.

  11. Compile and run the project.

    This opens the Office application and executes the following code.

RemoteOfflineRuntime offlineRuntime = new RemoteOfflineRuntime();
ISubscriptionManager subManager = offlineRuntime.GetSubscriptionManager();
ISubscription sub = subManager.GetSubscription("<EntityNameSpace>", "<EntityName>", "<ViewName>", "<SubscriptionName>");
sub.RequestRefresh(true);

Show: