title: SQLite auto increment issue
body: <p>I have created a SQLite database in C# and i used that query to create a table.</p>
  
  <pre><code>string q = "create table mains ( id int IDENTITY, desc varchar(20), PRIMARY KEY(id) )"; 
  ExecuteQuery(q);
  </code></pre>
  
  <p>And i tried adding a record like that :</p>
  
  <pre><code>string txtSQLQuery = "insert into  mains (desc) values ('" + textBox1.Text + "')";
  ExecuteQuery(txtSQLQuery);
  </code></pre>
  
  <p>I just added a desc and not ID , i guess it should auto increment the id field but it does not.
  Instead it adds the desc and the the ID field is empty every time i add a new record </p>
  
  <p>EDIT :
  i tried using :</p>
  
  <pre><code>id int PRIMARY KEY AUTOINCREMENT
  </code></pre>
  
  <p>But got Error :</p>
  
  <pre><code>SQLite.SQLiteException: near "AUTOINCREMENT":
  </code></pre>
  
  <p>EDIT 2 :
  I get that when i load the records :</p>
  
  <p><img src="https://i.stack.imgur.com/L9XcX.png" alt="enter image description here"></p>
  
  <p>There are no Numbers in the ID field at all.</p>