How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?
See Question&Answers more detail:osHow can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?
See Question&Answers more detail:osThere is some good info here: Create a SQL Server Compact Edition Database with C#
string connectionString = "DataSource="test.sdf"; Password="mypassword"";
SqlCeEngine en = new SqlCeEngine(connectionString);
en.CreateDatabase();