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 PathUsed 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
Sync a local SQL Server Everywhere Edition database using SQL Server Everywhere Edition Merge ReplicationUses SQL Server Everywhere Edition Merge Replication to sync changes to the local SQL Server Everywhere Edition database with a SQL Server publication