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