Programmatically create MS SQL Compact database file on a desktop

Question

Hello

Is it possible to create an SDF database file for MS SQL Server Compact on a desktop.?

I want to craete a desktop application which can create an SDF database file for copying it to a Windows Mobile device.

Is it possible and how?

thanks

Answer 1

Create how?

From Visual Studio? Open the Server Explorer and add a new Data Connection. Select SQL Compact as the data source, give it a file name and click Create.

From Code? Use the SqlCeEngine class. Give it a connection string and call Create.