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: 232

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

Related posts about .NET

Related posts about compact-framework