ADO.NET Sync Services in N Tier Architecture

Vishal Shukla

Rate me:

4.56/5 (26 votes)

7 Oct 2008CPOL4 min read

195.1K

1.8K

The article is a follow up article to Introduction to ADO.NET Sync Services and takes a look at how easily we can convert a 2 Tier Sync application to N tier using WCF services.

syncservicesntier_src.zip
- SyncServices2Tier.sln
- SyncServices2Tier
  - AdventureWorks.sdf
  - AdventureWorksDataSet.Designer.vb
  - AdventureWorksDataSet.xsc
  - AdventureWorksDataSet.xsd
  - AdventureWorksDataSet.xss
  - app.config
  - bin
    - Debug
      - AdventureWorks.sdf
      - SyncServices2Tier.exe
      - SyncServices2Tier.exe.config
      - SyncServices2Tier.pdb
      - SyncServices2Tier.vshost.exe
      - SyncServices2Tier.vshost.exe.config
      - SyncServices2Tier.vshost.exe.manifest
      - SyncServices2Tier.xml
  - Form1.Designer.vb
  - Form1.resx
  - Form1.vb
  - LocalDataCache1.Designer.vb
  - LocalDataCache1.sync
  - LocalDataCache1.vb
  - My Project
    - Application.Designer.vb
    - Application.myapp
    - AssemblyInfo.vb
    - DataSources
      - Microsoft.Synchronization.Data.SyncContext.datasource
      - Microsoft.Synchronization.Data.SyncSchema.datasource
      - Microsoft.Synchronization.Data.SyncServerInfo.datasource
    - Resources.Designer.vb
    - Resources.resx
    - Settings.Designer.vb
    - Settings.settings
  - obj
    - Debug
      - ResolveAssemblyReference.cache
      - SyncServices2Tier.exe
      - SyncServices2Tier.Form1.resources
      - SyncServices2Tier.pdb
      - SyncServices2Tier.Resources.resources
      - SyncServices2Tier.vbproj.FileListAbsolute.txt
      - SyncServices2Tier.vbproj.GenerateResource.Cache
      - SyncServices2Tier.xml
      - TempPE
        
        AdventureWorksDataSet.Designer.vb.dll
        
        LocalDataCache1.Designer.vb.dll
        
        My Project.Resources.Designer.vb.dll
        
        Service References.ServiceReference1.Reference.vb.dll
  - Service References
    - ServiceReference1
      - Arrays.xsd
      - configuration.svcinfo
      - configuration91.svcinfo
      - Microsoft.Synchronization.Data.xsd
      - Microsoft.Synchronization.xsd
      - Reference.svcmap
      - Reference.vb
      - service.wsdl
      - service.xsd
      - service1.xsd
      - service2.xsd
      - System.Data.xsd
  - SyncServices2Tier.vbproj
  - SyncServices2Tier.vbproj.user
- WcfSyncService1
  - App.config
  - bin
    - Debug
      - WcfSyncService1.dll
      - WcfSyncService1.dll.config
      - WcfSyncService1.pdb
      - WcfSyncService1.xml
  - IService1.vb
  - LocalDataCache1.Server.Designer.vb
  - LocalDataCache1.Server.sync
  - LocalDataCache1.Server.SyncContract.vb
  - LocalDataCache1.Server.vb
  - My Project
  - obj
    - Debug
      - ResolveAssemblyReference.cache
      - TempPE
        
        LocalDataCache1.Server.Designer.vb.dll
      - WcfSyncService1.dll
      - WcfSyncService1.pdb
      - WcfSyncService1.Resources.resources
      - WcfSyncService1.vbproj.FileListAbsolute.txt
      - WcfSyncService1.vbproj.GenerateResource.Cache
      - WcfSyncService1.xml
  - Service1.vb
  - WcfSyncService1.vbproj
  - WcfSyncService1.vbproj.user

Imports System
Imports System.Reflection
Imports System.Runtime.InteropServices

' General Information about an assembly is controlled through the following 
' set of attributes. Change these attribute values to modify the information
' associated with an assembly.

' Review the values of the assembly attributes

<Assembly: AssemblyTitle("WcfSyncService1")> 
<Assembly: AssemblyDescription("")> 
<Assembly: AssemblyCompany("")> 
<Assembly: AssemblyProduct("WcfSyncService1")> 
<Assembly: AssemblyCopyright("Copyright ©  2008")> 
<Assembly: AssemblyTrademark("")> 

<Assembly: ComVisible(False)>

'The following GUID is for the ID of the typelib if this project is exposed to COM
<Assembly: Guid("d6bfd4df-1dd3-4bb7-8846-a584b8d0389c")> 

' Version information for an assembly consists of the following four values:
'
'      Major Version
'      Minor Version 
'      Build Number
'      Revision
'
' You can specify all the values or you can default the Build and Revision Numbers 
' by using the '*' as shown below:
' <Assembly: AssemblyVersion("1.0.*")> 

<Assembly: AssemblyVersion("1.0.0.0")> 
<Assembly: AssemblyFileVersion("1.0.0.0")>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Vishal Shukla

Architect L&T Infotech

India

Vishal has over 17 years of IT experience with over 15 years on Microsoft technologies from QW Basic to .net 4.5. Vishal works as a Lead Architect for the L&T Infotech. He has given various presentaions at code camps, Teched Tweener and various user group events.
Winner of INETA Community Champions award for 2008 Q3.
Microsoft VB .Net MVP 2009-2011

ADO.NET Sync Services in N Tier Architecture

License

Comments and Discussions