The connection string for SqlCE can contain a path like this:

Data Source = C:\MyApp\MyApp.sdf

This works great if the database will always be in the same folder, but I would like my install to copy the database to the Common Application Folder for all Users. So in Windows XP, the folder might be:

C:\Documents and Settings\All Users\Application Data\MyApp

The Common Application Folder in Windows Vista is totally different. So I would like to default my connection string to just the database name. Then add logic to the mmBuisnessObject.GetConnectionString() method to add the correct path.

What is the best way to accomplish this? Can I add a Factory method? Thanks in advance for any help.

Kind Regards,

Mat