SQL Server Compact Edition - Create Database Tables
Posted
by Lennie De Villiers
on Stack Overflow
See other posts from Stack Overflow
or by Lennie De Villiers
Published on 2009-12-18T19:45:34Z
Indexed on
2010/05/01
19:07 UTC
Read the original article
Hit count: 210
Hi, I got it right to create a SQL Server CE database table using the code below:
string connectionString = "DataSource=\"test.sdf\"; Password=\"mypassword\"";
SqlCeEngine en = new SqlCeEngine(connectionString);
en.CreateDatabase();
But how do I create my database tables and insert data? I've got the SQL created statements stored in the application Resource location.
© Stack Overflow or respective owner
