SQL Server Mobile, SQL Server Everywhere Edition Code Snippets

When working with SQL Server Mobile / SQL Server Everywhere Edition (SSEv) here are a few code snippets that can be very useful. Visual Studio 2005 incorporated a concept of Code Snippets which allows you to enter a shortcut in the code editor and Visual Studio will expand that shortcut into code with replacement regions. These code snippets are written in VB, but they could easily be converted to C#. ...no, I don't currently plan to convert them, but if someone would like to I'll be glad to post those samples and give credit.

SQL Server Everywhere Edition Connection String Conversion to Physical Path
Used to update the SQL Server Everywhere Edition Connection String to a fully qualified path for use in Click-Once scenarios and MSI type scenarios.
Snippet is designed to be used in the partial class of the settings file. Click the settings tab on the application designer and select view code. Handle the event for Settings_Loaded

Verifies a SQL Server Everywhere Edition database exists
Uses a SqlCe Connection String to verify the database already exists on disk. If not, the database will automatically be created

SQL Server Everywhere Edition Updatable Result Set

Creates an updatable resultset against a SQL Server Everywhere Edition database

Sync a local SQL Server Everywhere Edition database using SQL Server Everywhere Edition Merge Replication
Uses SQL Server Everywhere Edition Merge Replication to sync changes to the local SQL Server Everywhere Edition database with a SQL Server publication