My.Settings type "string" vs "connection string"

What is the difference of these types in My.Settings? For what do I use "connectionstring"?

What (& why) would I use for a local SQL Compact database?

What would I use if I wanted the database location to be chosen/changed in a program options form?

Would it matter if I want a per user setting or not? I don't, I want 开发者_StackOverflowprogram to run identical for all Windows user-logins (On the same PC).

Thanks!

If you use the ConnectionString type it is stored in a different section of the config. Not all that different in use but you don't get to choose between Application and User setting (it's forced to Application).

What (& why) would I use for a local SQL-COMPACT database?

I want program to run identical for all users.

There might be a small conflict here. SQL-CE databases are not suitable for sharing (concurrently) between users.

If you mean "all users on the same PC" there is no problem, use a Connectionstring or a custom Application setting. Only you can't normally change that form the program itself (no Write privileges in ProgramFiles).