MilindL

>>btw does the syncing stuff work other databases as well?
Unfortunately, no. The Sync Services runtime does not support non-SQL Server databases.

>> The moment the tables are synchronized (13:21) the order data changes
Indeed.

This is because after the sync I did a fill for the datasets. This clears and refills that dataset.
A better approach is to use merge.

Me.NorthwindDataSet.Shippers.Merge(Me.ShippersTableAdapter.GetData())

> First of all this all seems a little too good to be true
Thank you!

> is if there is an easy way that my database changes can automatically appear in the local database cache?  Or will i also have to create a new local cache with every database change?

There is no _easy_ way for the changes to automatically appear. But the good news is that with ADO .NET SyncServices you do not need to create a new local cache every time.

The sync designer, as I show in the demo, creates change tracking information on the server. Thus whenever you call Synchronize() you fetch just what's changed since the last sync and just update your existing local cache.

I should point out, however, that currently we support only SQL Server Compact.

You can use LINQ to SQL with SQL Server Compact (although the OR designer in VS2008 does not support SQL Server Compact). You can define your DataContext (by hand) and the appropriate classes and use them.

Thanks.

Milind Lele
PM, Visual Basic
 

It is not a recommendation to move all mid-tier logic to the data tier. Some of it can be. One must weigh and trade off data-traffic with server utilization.

IOW you would never move all your business logic into the data tier.

Hope that helps.

Milind

FYI: Here's a great article that might help answer some of the questions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp

Thanks Chris. The connection node in server explorer has a context menu command "Enable SQLCLR debugging". You can check that to enable this. Also when you create a SQLCLR project you are prompted for a connection to use as the target for your assembly. If this is not enabled for this connection, you will be prompted to.