Create SQL Server CE database file programmatically

c# .net sql-server database sql-server-ce
Andrew Arnott picture Andrew Arnott · Sep 28, 2009 · Viewed 36.1k times · Source

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

Answer

D'Arcy Rittich picture D'Arcy Rittich · Sep 28, 2009

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

Related questions

Received an invalid column length from the bcp client for colid 6

I want to bulk upload csv file data to sql server 2005 from c# code but I am encountering the below error - Received an invalid column length from the bcp client for colid 6. when bulk copy write to database server

Read More
What to use for Size argument in Database.AddOutParameter when returning a string?

I'm getting a string as an output parameter, and need to know what to set for the Size argument in the call to AddOutParameter. I know I could just use some huge number, like int.MaxValue, but want to know …

Read More
C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int tinyint money Approximate Numerics float real Date and Time date datetimeoffset datetime2 smalldatetime datetime time Character Strings …

Read More