title: Cannot insert to SQL Server CE with autoincrement
body: <p>I am unable to insert new row to a SQL Server CE 3.5 table due to an auto-increment column</p>
  
  <p>My schema is as simple as:</p>
  
  <pre><code>@"CREATE TABLE DataTable ("Foo_ID int PRIMARY KEY IDENTITY, " +
                            "FooName NVARCHAR(200) NOT NULL)
  </code></pre>
  
  <p>And my insert statement in C#</p>
  
  <pre><code>SqlCeCommand cmd = new SqlCeCommand(@"INSERT INTO DataTable VALUES(@Foo_ID, @FooName)", con))
  conn.Open();
  cmd.Parameters.Add(new SqlCeParameter("FooName", "test123"));
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>Then I get the error:</p>
  
  <blockquote>
    <p><em>System.IndexOutOfRangeException: An SqlCeParameter with ParameterName
    'Foo_ID' is not contained by this SqlCeParameterCollection</em></p>
  </blockquote>