Create SQL Server Compact database file programmatically

Question

How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?

Answer 1

There 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();