Database Synchronization with the Microsoft Sync Framework: Listing 1.

Calling the custom synchronization library from Visual Basic.

Public Sub Sample_SQLStandard_SQLExpress_Sync()
  Dim dbSS8_SX8_TT_SyncInfo As New DatabaseSyncInfo
  Dim dbSS8_SX8_TT_Helper As SynchronizationHelper

  dbSS8_SX8_TT_SyncInfo.LocalConnectionString = 
    My.Settings.SQLServerTrackingTablesConnectionString
  dbSS8_SX8_TT_SyncInfo.LocalDriverType = eSyncDriverType.SQLServer
  dbSS8_SX8_TT_SyncInfo.RemoteConnectionString = 
    My.Settings.SQLExpressTrackingTablesConnectionString
  dbSS8_SX8_TT_SyncInfo.RemoteDriverType = eSyncDriverType.SQLServer
  dbSS8_SX8_TT_SyncInfo.ScopeName = My.Settings.ScopeName
  dbSS8_SX8_TT_SyncInfo.FillSyncTables(My.Settings.SyncTables)
  dbSS8_SX8_TT_Helper = New SynchronizationHelper(dbSS8_SX8_TT_SyncInfo)
  Dim SyncStats As Microsoft.Synchronization.SyncOperationStatistics = 
    dbSS8_SX8_TT_Helper.DoSync(Nothing)
  'Display SyncStats to user if desired
  'The DoSync() parameter is an optional ListBox to show in-progress 
    status information if desired
  End Sub

About the Author

Joe Kunk is a Microsoft MVP in Visual Basic, three-time president of the Greater Lansing User Group for .NET, and developer for Dart Container Corporation of Mason, Michigan. He's been developing software for over 30 years and has worked in the education, government, financial and manufacturing industries. Kunk's co-authored the book "Professional DevExpress ASP.NET Controls" (Wrox Programmer to Programmer, 2009). He can be reached via email at [email protected].

comments powered by Disqus

Featured

  • Move Over, Stack Overflow: Microsoft Launches Q&A for .NET

    Stack Overflow probably isn't worried, but Microsoft has launched its own Q&A site for all things .NET, seeking to provide a one-stop-shop for getting .NET technical questions answered by the community.

  • Developer Decries WinForms-to-Blazor Performance Degradation

    Since shipping .NET 5, Visual Studio 2019 v16.8 and more goodies recently, Microsoft has been touting speed improvements in many components -- including the red-hot Blazor project -- but some real-world developers are finding different results.

  • Google Cloud Functions Supports .NET Core 3.1 (but not .NET 5)

    Google Cloud Functions -- often used for serverless, event-driven projects -- now supports .NET, but the new support is a release behind Microsoft's latest .NET offering.

  • Binary Classification Using PyTorch: Model Accuracy

    In the final article of a four-part series on binary classification using PyTorch, Dr. James McCaffrey of Microsoft Research shows how to evaluate the accuracy of a trained model, save a model to file, and use a model to make predictions.

  • Visual Basic in .NET 5: Ready for WinForms Apps

    With the milestone .NET 5 and Visual Studio 2019 v16.8 releases now out, Microsoft is reminding Visual Basic coders that their favorite programming language enjoys full support and the troublesome Windows Forms Designer is even complete -- almost.

Upcoming Events