Some demo videos of various features and components that enable Occasionally Connected Applications
I’ll continue to add links to videos of demos for various scenarios.
Visual Studio 2005 (Whidbey) Features
Using SQL Server Mobile w/Visual Studio 2005 – 7 minutes
A quick walkthrough of building an Order Form including configuring ComboBoxes lookup controls. Using the Data Sources Window you can easily consume SQL Mobile databases to create a Strongly Typed Dataset. The demo includes how to load the SQL Mobile runtime with your app and ClickOnce deploy the app without requiring administrative rights.
Using Remote Data Access (RDA) for lightweight, simple sync scenarios - 14 minutes
An overview of using RDA including a demo walkthrough. Sample code in video
Configuring RDA Server Components - 7 Minutes
A walkthrough of how to configure IIS to broker RDA queries to your SQL Server
Code Snippets: http://blogs.msdn.com/stevelasker/archive/2006/05/02/SqleCodeSnipetts.aspx