title: Create Table with LINQ To SQL / SQL CE
body: <p>I am new to SQL and I tried create a table with LINQ To SQL.</p>
  
  <p>First I create DataContext object:</p>
  
  <pre><code>        const string connStr = @"Spiri_SQL_CE_DB.sdf";
          _dc = new Spiri_SQL_CE_DB(connStr);
  </code></pre>
  
  <p>And the I try create DB table with this method:</p>
  
  <pre><code>public void CreateUserTab(string nick)
  {        
      string sqlCdm = string.Format(CultureInfo.InvariantCulture, "CREATE TABLE {0} (Nick nvarchar(30) PRIMARY KEY, AzetID nvarchar(30), RpText nvarchar(300), Your bit, Sing nvarchar(30), Time DateTime, OriginalTxt nvarchar(300))",nick);
  
      _dc.ExecuteCommand(sqlCdm);
  
      _dc.SubmitChanges();
  }
  </code></pre>
  
  <p><strong>1.</strong></p>
  
  <p>First problem is that I use this method, create table and close app. But new created table is not in database.</p>
  
  <p>I think that changes which I do on database are not saved DB. If I check db file in server explorer I don’t see new db table.</p>
  
  <p><strong>2.</strong>
  And second problem is.</p>
  
  <p>For example I have class which represent DB table, here is it:</p>
  
  <pre><code>[Table]
  public class User
  {
      [Column(IsPrimaryKey = true)]
      public string Nick { get; set; }
  
      [Column]
      public string AzetId { get; set; }
  
      [Column]
      public String RpText { get; set; }
  
      [Column]
      public bool Your { get; set; }
  
      [Column]
      public string Sing { get; set; }
  
      [Column]
      public DateTime Time { get; set; }
  
      [Column]
      public string OriginalTxt { get; set; }
  }
  </code></pre>
  
  <p>I know that is possible mapping SQL table on CLR class Tabel. It’s possible create DB table (with specific name) with this class?</p>
  
  <p>I would like omited SQL command in my code, is it possible create db table from CLR object?</p>
  
  <p><strong>3.</strong></p>
  
  <p>And the last question is:</p>
  
  <p>Scenario is:</p>
  
  <p>I have SQL compact DB file, it consist one table User1 type of <code>Table&lt;User&gt;</code>, I generate with SqlMetal *dbml file.</p>
  
  <p>Then I from code create another tables User2, User3 ... UserN. </p>
  
  <p>Close app.</p>
  
  <p>It possible have access to db table User2 ... UserN? Or I must create another dbml file ?</p>