title: How to enable auto-increment with Sql compact & C#
body: <p>I'm using C# 2010 Express.</p>
  
  <p>I have created a SQL Server CE database file (<code>.sdf</code>) then created Information table and ID, Name, City columns with Database Explorer. I want to save names and city user will write to the form. The auto-increment option is disabled in Database explorer and Properties windows. When I'm saving something to that database i must change the ID manually, how can I make ID column auto-increment enabled?</p>