.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

In Sync: Creating Synchronization Providers with the Sync Framework

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

The Sync Framework can be used to build apps that synchronize data from any data store using any protocol over a network. We'll show you how it works and get you started building a custom sync provider.

Joydip Kanjilal

MSDN Magazine August 2010

View Complete Post

More Related Resource Links

Sync Up: Manage Your Data Effectively With The Microsoft Sync Framework


Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.

James Yip

MSDN Magazine April 2009

How to add Microsoft Sync Framework to Prerequisites Dialog Box

Hello everyone. I created a setup project in Visual Studio 2008 and I need to add microsoft sync framework as a prerequisite. But microsoft sync framework option is not in the Prerequisites Dialog Box. How can I add microsoft sync framework as a prerequisite to my project?

MS Sync Framework INSERT Trigger

Hello, Due to the sync framework insert trigger my business logic was broke. I was getting resulted in a StaleStateException (-1 rows affected, expected 1). error. I looked at the sync insert trigger and found a strange thing. There is an update call before inserting to the tracking table. This update call joins with the tracking table for inserted record. How it is going update the record which really do not exists! I removed the UPDATE call and it works fine now. However I am not sure the reason behind the presence of the UPDATE call withing the INSERT trigger. Here is the sample trigger: ALTER TRIGGER MYTABLE_insert_trigger] ON MYTABLE FOR INSERT AS UPDATE [side] SET [sync_row_is_tombstone] = 0, [local_update_peer_key] = 0, [restore_timestamp] = NULL, [update_scope_local_id] = NULL, [last_change_datetime] = GETDATE(), [ID] = [i].[ID] FROM [sync].[MYTABLE_tracking] [side] JOIN INSERTED [i] ON [side].[PrimaryKey1] = [i].[PrimaryKey1] AND [side].[PrimaryKey2] = [i].[PrimaryKey2] INSERT INTO [sync].[MYTABLE_tracking] ([i].[PrimaryKey1], [i].[PrimaryKey2], [create_scope_local_id], [local_create_peer_key], [local_create_peer_timestamp], [update_scope_local_id], [local_update_peer_key], [sync_row_is_tombstone], [last_change_datetime], [restore_timestamp], [i].[ID]) SELECT [i].[PrimaryKey1], [i].[PrimaryKey2], NULL, 0, @@DBTS+1, NULL, 0, 0, GETDATE(), NULL, [i].[ID] FR

Sync Framework 2.1 The modified data Cannot synchronized

In the server database table delete and add new data can be downloaded to the client but the table has a field on a data modification cannot be synchronized to the client

DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("testScope");
  DbSyncTableDescription tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable(tab, serverConn);
  SqlSyncScopeProvisioning serverProvision = new SqlSyncScopeProvisioning(serverConn, scopeDesc);

DbSyncScopeDescription scopeDesc = SqlSyncDescriptionBuilder.GetDescriptionForScope("testScope"), serverConn);
  SqlSyncScopeProvisioning clientProvision = new SqlSyncScopeProvisioning(clientConn, scopeDesc);

Creating a Generic Entity Framework 4.0 Repository

With .NET 4.0 right around the corner, I thought it would be cool to download Visual Studio 2010 beta 2 and start playing around with the next release of Entity Framework.

The initial release of Entity Framework came with a great deal of criticism. To make matters worse, there was a large uproar when it was rumored that Microsoft would be abandoning LINQ to SQL, in favor of Entity Framework. This was because, at the time, many developers felt Entity Framework was an inferior technology to LINQ to SQL. To set things right, Microsoft proactively moved forward with improving Entity Framework, in time for the 4.0 release of the .NET Framework. This is good news because my initial impressions, so far, have been nothing but positive.

Any framework for creating a job scheduler service?


Just curious to know if there was any official Microsoft code blocks, classes, or such for writing a service that runs other assemblies or WCF services?  That can be configured easily from a web page, pre-coded, for running tasks at certain times on certain recurring intervals?  I've already built one but am open to anything done better- which I'm sure there is.  Thanks!!!

Class To Contract: Enrich Your XML Serialization With Schema Providers In The .NET Framework


The Microsoft .NET Framework 1.x provided minimal options for mapping classes to schemas and serializing objects to XML documents, making this sort of mapping quite a challenge. The .NET Framework 2.0 changes all this with Schema providers and the IXmlSerializable interface.

Keith Pijanowski

MSDN Magazine June 2006

Video: Getting Started SharePoint 2010: Creating .NET Framework Types for a Business Connectivity Se

This demonstration shows how to use Visual Studio 2010 to create Business Data Connectivity projects that incorporate external data into SharePoint solutions. (Length: 8:33)

How to sync between UpdateListItems() and GetListItems() web services

I am using Javascript to call the UpdateListItems() webservice through SOAP to add an entry to a list then I am using the GetListItems() webservice to query the number of items in that list. I am successful in adding an new entry in the list, but when I query the GetListItems(), it does not return the number of entries (items) in the list unless it was entered via the SharePoint GUI, not the UpdateListItems() routine I have written. I will add the source code for your reference and help.: var response; function SOAPUtilForHitCount(data,action,listName,listPath) { this.data = data; this.listName = listName; this.listPath = listPath; this.SOAPHeader =  function() { var stack = []; stack.push("<?xml version='1.0' encoding='utf-8'?>"); stack.push("<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"); return (stack.join("")); } this.SOAPBody =  function() { var stack = []; if(action=="count") { stack.push("<soap:Body>"); stack.push("<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"); stack.push("<listName>" + this.listName + "</listName><query><Query xmlns=''><Where><Eq><Fie

SQL server 2008 r2 Data sync question???

Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally?  I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does that have to do with a sync functionality that runs locally to keep my db's sync'd?   Thanks, SL

Claims Walkthrough: Creating Trusted Login Providers (SAML Sign-in) for SharePoint 2010

Learn how to create a custom security token service (STS) and set up a trust relationship between a SharePoint 2010 farm and the custom STS

Sharepoint 2010: User Profile Sync with Person attributes

Sorry for opening another post following this, but I think this case is quite concrete: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/2fa02093-630e-4131-bdc7-0b979067f601 When trying to configure in Sharepoint 2010 - User Profile Application, an additional sync source from BDC (as at least, one LDAP Profile is required). The first approach was to create a straightforward SQL Connection with SP Designer, and it seemed everything ok, except I'm not able to setup synchronization of "Manager" property, which is great in order to see Silverlight Organization Explorer Webpart. As I have read in the previous post, someone pointed to setup a BDC with Visual Studio 2010, so one attribute is of type: Microsoft.SharePoint.SPUser. It seamed very logical, and so I tried to do such task. Once I have deployed correctly a BDC with this strong type (SPUser), the result is that I'm still unable to see any attribute when trying to synchronize Manager attribute. In Sharepoint 2007 this was possible, but not able in SP 2010. Any idea of how to do it? Just a bug? I have one very dirty workaround: setup a Timer job to run after Sync, so I can setup this field by code. But, for doing this, I would not need to run Sync process with BDC anymore.    Evotec Consulting

sync your shairpoint data with your file server

is it posseble to sync al the files on my file server to my shairpoint server.   now its done with shairpoint workspace. bath when a employee makes a new file on the file server it wont sync

Sharepoint calendar sync with personal outlook calendar

Hello I want our users to be able to make meetings in sharepoint and see it directly in their personal calendar, also when other users subscribe and unsubcribe it should be seen in their personal calendar. I know its possible to "Link/Connect with outlook" but this makes a new "Other Calendar" which u can put side to side with your own calender. I would like to have it directly imported into my personal outlook calendar.  Is there any known information , links about this?

Sync calendar events between two web applications

Hi, I wanted to check if it is possible to sync calendar events between two different web applications in WSS 3.0. Both web applications are in the same farm. I want to know if it is possible to design such workflow in SharePoint Designer 2007 or do I need to use Visual Studio?Thank you.

Can ASP.NET be used in sync with RDP to create a remote desktop manager ?

Hello all,      I am new to .NET but is in a circumstance were i need to submit a project in .NET ( not necessarily a web application - even a client server one would suffice ). I need this application to be able to : 1. Connect to remote client from my server computer2. See client computer's screen and work on it from my server to fix problems there3. Drag and drop files between my local server's screen and the screen on my computer displaying the remote client's screen4. Should be able to start a chat session ( text/audio) with this remote client's user to help fix him/her the problem5. If i am installing any s/w in the client - then i should get back this control over the client computer even after i do a system restart of the client computer from the serverMy doubt is : 1. Can i build a remote desktop control manager application as described above using .NET be it asp.net/winforms ?2. If so what all technologies do i need to use and which all protocols will i be using ideally - like ASP.NET, ADO, Winforms - RDP, FTP, HTTP etc ?3. If at all feasible - how complex is this project on a level of 1 to 10, 10 being the highest ?I am sorry if i am totally out of place or wrong. I am a novice and is new to .NETThanking you all in advance for your valuable help and suggestions.                 

MDAC SDK - why is the list of OLE DB providers different to what I see when creating a UDL file?

In MDAC 2.8 SDK on Windows Server 2003 SE x64.  Using RowsetViewer 2.70, list of datasources is not same as when I edit a UDL file on the same server.  Why is this? I want to test a specific OLE DB provider, but it's not on the list within the SDK's tools.  I can see the specific provider in the registry, and it has the correct format as defined in the SDK's OLE DB documentation for providers, so It's installed correctly.  Note, the provider works okay with the application and tests okay in the UDL file edit dialog.  It's just the SDK that I can't use it in :-( Alternately, is there another (3rd party?) tool I could use?  All I'm looking to to do is run simple SQL query test via OLE DB to get timings.  Note, I'm a programmer, but not used to ADO or OLE DB interfaces - that's why I'm looking for a ready made tool :-) Any help would be be great, thanks, Richard.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend