This post originated from an RSS feed registered with .NET Buzz
by Doug Thews.
Original Post: Using SqlCeReplication with a WinForms App
Feed Title: IlluminatiLand
Feed URL: http://apps5.oingo.com/apps/domainpark/domainpark.cgi?client=netw8744&s=JETBRAINS.COM
Feed Description: A technology blog for people enlightened enough to think for themselves
I received a question recently on my CF.NET/SQL CE article in October's issue of Visual Studio Magazine. .NET does not offer a class similar to SqlCeReplication, but I do think it's possible to use the same class in a standard WinForms application. Doing so would create a single-user file database on the local machine, but at least you could programmatically replicate to the desktop using the SqlCeReplication class. I'll be doing some initial testing and post my result.
Now, probably the better way to do this is to create your own SqlReplication class to mimic the objects and properties of SqlCeReplication, but make the destination a local MSDE database. You could make direct calls to the SQL replication stored procedures for management of the Subscriptions and Publications. Heck, it might even make a sellable add-on for .NET developers. Thoughts on this are welcome.