1. From the File menu, point to Add, and then click New Project.

2. Name the project MiddleTierServiceLibrary.

3. Click WCF under Project types, followed by the WCF Service Library template.

4. Click OK.

   The MiddleTierServiceLibrary project is created and added to Solution Explorer.

1. Right-click the MiddleTierServiceLibrary project, point to Add, and then click New Item.

2. Click the Local Database Cache template and type NorthwindCache.sync in the Name box.

3. Click Add.

   A NorthwindCache.sync file is added to Solution Explorer and the Configure Data Synchronization dialog box appears. NorthwindCache.sync stores synchronization configuration information.

1. Use the Configure Data Synchronization dialog box to create a connection to the Northwind database that you installed as a prerequisite to this walkthrough. This is the remote database external to your smart device application. You may either select an existing Server connection to the SQL Server Northwind database, or, if a connection does not exist, click New to create a new connection to the SQL Server Northwind database.

   Note:
   You may enable SQL Server change tracking, but only after the connection to the remote database server is configured to connect to a SQL Server 2008 database. For more information, see How to: Configure Data Synchronization to Use SQL Server Change Tracking.

2. Accept the default value of Northwind.sdf (new) for the Client connection. The Configure Data Synchronization dialog box creates a new SQL Server Compact 3.5 database and adds it to your project. For more information about the available data connection options, see How to: Create a Data Connection to the Northwind Database.

   After you select the server connection, the Configure Data Synchronization dialog box queries the remote database on the server for a list of available tables. This dialog box also enables the Add button, but only after the list of available tables is retrieved.

   Note:
   Notice that the OK button is not enabled at the conclusion of this step. This is because no tables have been selected for synchronization. The next section explains how to add tables.

1. Click Add to open the Configure Tables for Offline Use dialog box.

2. Select the Customers table.

   Note:
   You can modify the default synchronization behavior for each table that you select in the Configure Tables for Offline Use dialog box. For more information, see How to: Configure Data Synchronization in an Application.

3. Accept the default column and table values. Click OK. The Configure Data Synchronization dialog box will create tracking columns and a deleted-items table.

   The Customers table is added to the Cached Tables list.

1. In the Configure Data Synchronization dialog box, click Advanced.

2. On the Client project location drop down menu, select OCSDeviceApp.

3. Click OK.

   Components will be divided between the client project and the server project, after data synchronization is configured. Meanwhile, the Generate SQL scripts dialog box appears. By default, it generates scripts that maintain tracking columns and tables for deleted and updated items on the server database.

4. Click OK.

   The generated SQL scripts are saved in the server project. The Northwind.sdf client database is created in the client project and synchronized with the server database for the first time.

5. When the Data Source Configuration Wizard appears, select the Customers table.

6. Click Finish.

7. NorthwindDataSet.xsd is added to the client project and all dialog boxes close.

1. In Solution Explorer, double-click NorthwindCache.SyncContract.cs (or .vb) to open the file in the Code Editor.

2. Add the XmlSerializerFormat() attribute just before the definition INorthwindSyncContract. The Code Editor should display:

   C#

   [ServiceContractAttribute()]
   [XmlSerializerFormat()]
   public interface INorthwindCacheSyncContract {
   <ServiceContractAttribute()> _
   <XmlSerializerFormat()> _
   Public Interface INorthwindCacheSyncContract
   

3. In Solution Explorer, double-click App.config.

4. Make the following XML modifications to the App.config file. These changes configure the project to host the NorthwindCacheSyncService generated by the Configure Data Synchronization dialog box instead of the default service (Service1) that is generated by the WCF project template.

   1. Change <service name="MiddleTierServiceLibrary.Service1" behaviorConfiguration="MiddleTierServiceLibrary.Service1Behavior"> to <service name="MiddleTierServiceLibrary.NorthwindCacheSyncService" behaviorConfiguration="MiddleTierServiceLibrary. NorthwindCacheSyncServiceBehavior">

   2. Change <add baseAddress="http://localhost:8731/Design_Time_Addresses/MiddleTierServiceLibrary/Service1/" /> to <add baseAddress="http://<your computer name>:8731/NorthwindCacheSyncService/" />

   3. Change <endpoint address="" binding="wsHttpBinding" contract="MiddleTierServiceLibrary.IService1"> to <endpoint address="" binding="basicHttpBinding" contract="MiddleTierServiceLibrary. INorthwindCacheSyncContract">

      Note:
      wsHttpBinding is not supported on devices.

   4. Change <dns value="localhost"/> to <dns value="<your computer name>"/>

   5. Change <behavior name="MiddleTierServiceLibrary.Service1Behavior"> to <behavior name="MiddleTierServiceLibrary.NorthwindCacheSyncServiceBehavior">

5. Right-click MiddleTierServiceLibrary in Solution Explorer and click Set as StartUp Project.

6. To start the WCF Service, click Start Without Debugging in the Debug menu.

   The Deploy OCSDeviceApp dialog box appears.

7. Click Cancel and then Yes to continue.

   Note:
   You are only starting the WCF service: the device emulator is not yet required.

   The WCF Service Host is started (icon appears in notification area) and hosts the service. The WCF Test Client appears and enables you to test the service.

1. In Solution Explorer, right-click OCSDeviceApp, and then click Add Web Reference.

   The Add Web Reference dialog box appears.

2. Type the address of the NorthwindCacheSyncService in the URL box, and then click Go.

   Once the NorthwindCacheSyncService Web service is found, the Add Reference button is enabled.

   Note:
   The service address may be found in the App.config file.

3. Name the Web reference NorthwindCacheWebRef, and then click Add Reference.

   NorthwindCacheWebRef appears under Web References in Solution Explorer. Visual Studio generates the file Reference.cs: however, you will not be able to see this file in Solution Explorer.

4. Perform the following steps to open and modify Reference.cs:

   1. Double-click NorthwindCacheWebRef to open it in Object Browser.

   2. Expand the node OCSDeviceApp.NorthwindCacheWebRef.

   3. Right-click NorthwindCacheSyncService and click Go To Definition.

      Reference.cs is opened in the Code Editor.

   4. Add the following code after the last using or imports statement:

      [C#]

      using Microsoft.Synchronization;
      using Microsoft.Synchronization.Data;
      

      [Visual Basic]

      Imports Microsoft.Synchronization.Data
      Imports Microsoft.Synchronization
      

   5. Remove all classes and enumerations in the file except for NorthwindCacheSyncService.

      Note:
      The removed types are already defined in the newly imported Microsoft.Synchronization and Microsoft.Synchronization.Data namespaces.

1. In Solution Explorer, double-click Form1 to open it in the Visual Studio designer.

2. Drag the Customers node from the Data Sources window onto Form1.

In Form1, click the left menu item and type Synchronize Now. Set its Name property to SynchronizeMenuItem.

Note:
The user will ultimately click Synchronize Now to start the synchronization process.

The DataGridView displays the Customers table from the local database cache (the Northwind.sdf database located in the project).

1. In Solution Explorer, Double-click Form1 to open it in the designer.

2. Click the menu item that is located on the right side of the form and type Insert Row. Set the menu item's Name property to InsertRowMenuItem.

3. Double-click the Insert Row button to create a menu-click event handler and open the form in the Code Editor.

4. Add code to connect to (and insert a row in) the local SQL Server Compact database.

   Visual Basic

   Dim conn = New System.Data.SqlServerCe.SqlCeConnection( _
       "Data Source=" + (System.IO.Path.Combine(System.IO.Path.GetDirectoryName( _
           System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase), "Northwind.sdf") + _
       ";Max Database Size=2047"))
   
   Try
       ' Connect to the local database
       conn.Open()
   
       ' Insert a row
       Dim cmd = conn.CreateCommand()
       cmd.CommandText = "INSERT INTO Customers ([CustomerID], [CompanyName]) Values('NEWRW', 'Northwind Traders')"
       cmd.ExecuteNonQuery()
   
   
   Catch ex As Exception
   Finally
       conn.Close()
   End Try
   
   ' Reload the DataSet/Datagrid from the local database
   CustomersTableAdapter.Fill(Me.NorthwindDataSet.Customers)
   
   

   C#

   System.Data.SqlServerCe.SqlCeConnection conn = new System.Data.SqlServerCe.SqlCeConnection(
       ("Data Source=" + (System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase), "Northwind.sdf") + ";Max Database Size=2047")));
   try
   {
       // Connect to the local database
       conn.Open();
       System.Data.SqlServerCe.SqlCeCommand cmd = conn.CreateCommand();
   
       // Insert a row
       cmd.CommandText = "INSERT INTO Customers ([CustomerID], [CompanyName]) Values('NEWRW', 'Northwind Traders')";
       cmd.ExecuteNonQuery();
   }
   
   finally
   {
       conn.Close();
   }
   
   // Reload the DataSet/Datagrid from the local database
   customersTableAdapter.Fill(northwindDataSet.Customers);
   
   

   InsertRowMenuItem inserts a new row in the Customers table in the local database.

   Note:
   Later, when you test the application, you can verify that the new row appears in the remote database following synchronization.