title: ASP.NET LINQ to SQL SubmitChanges() doesn't update the database
body: <p>In my 2nd ASP.NET MVC project I'm facing a very weird problem: when I call the SubmitChanges method of the DataContext class, nothing updates in the database. It's weird because everything works fine with my first project.</p>
  
  <p>I'm using a remote database created in Sql Server Management Studio, I tried doing some queries there and in Visual Studio 2010 (where I have the connection to the database), they all work.</p>
  
  <p>Where might the problem be hidden?</p>
  
  <pre><code>DBDataContext DB = new DBDataContext();
  var myuser = DB.Users.Single(u =&gt; u.ID == id);
  myuser.Age = 45;
  DB.SubmitChanges();
  </code></pre>
  
  <p><strong>SOLUTION</strong></p>
  
  <p>This is embarrassing :D Indeed I didn't have a primary key. Now it works!</p>
  
  <p>Thanks to everybody!</p>