title: Changes do not get saved permanently into SQL Server Compact edition
body: <p>I am having a weird problem. I am using vs2012 to connect to SQL Server CE and executing some insert queries.</p>
  
  <pre><code>public void EstablishConnection()
  {
          connection = new SqlCeConnection("Data Source=DataDump.sdf;Persist Security Info=False;");
          try
          {
              connection.Open();
              Console.WriteLine("Connection Successful");
          }
          catch (Exception exception)
          {
              Console.WriteLine(exception.Message);
          }
      }
  
      public void AddRecord(string link,string content)
      {
          int num = 0;
          var command = new SqlCeCommand("INSERT INTO Webpages(Link,Data) VALUES('"+link+"','"+content+"');",connection);
          num = command.ExecuteNonQuery();
          Console.WriteLine("Command Successful rows affected"+num);
          var cmd2 = new SqlCeCommand("SELECT * FROM Webpages",connection);
          SqlCeDataReader reader = cmd2.ExecuteReader();
          while (reader.Read())
          {
              Console.WriteLine(reader[0]);
              Console.WriteLine(reader[1]);   
          }
      }
  </code></pre>
  
  <p>However I am having the problem that once VS is closed and when later I open it to display the data, the data is gone as it was never saved</p>
  
  <p>How is that possible when it is clear then it executed the query?</p>