title: WebMatrix set Insert_Identity on
body: <p>I've made a database in WebMatrix. And i've set the <code>isIdentity</code> <code>true</code> but the table wont auto increment. It gives me an error saying that "Insert_Identity is off".</p>
  
  <p>How do I turn it on?.</p>
  
  <p>The SQL code that I used to create the table</p>
  
  <pre><code>create table Product
  (
      _ID integer identity not null,
      primary key(_ID),
      unique(_ID),
      Name varchar(50) not null
  )
  </code></pre>
  
  <p>And here is how my GUI looks like
  <img src="https://i.stack.imgur.com/pKPUr.png" alt="enter image description here"></p>
  
  <p>Then I try added data to the table
  <img src="https://i.stack.imgur.com/idTKD.png" alt="enter image description here"></p>
  
  <p>And the the error happens.
  I've got no clue on whats going on</p>