title: How to return autoincrement value in insert query in SQLite?
body: <p>In my project I use <a href="http://sqlite.phxsoftware.com/" rel="noreferrer">System.Data.SQLite</a>. Database has table <code>Tags</code>, which contains autoincrement primary field <code>ID</code> (type <code>Integer</code>). When I write:</p>
  
  <pre><code>using (SQLiteCommand command = conn.CreateCommand())
  {
     command.CommandText = "insert into Tags(name) values(@name) returning into @id";
     command.Parameters.Add("@id", DbType.Int32).Direction = ParameterDirection.Output;
     command.ExecuteNonQuery();
  }
  </code></pre>
  
  <p>Visual Studio said that the operation is not supported. How to fix it?</p>
  
  <p>Error occurs on line:</p>
  
  <pre><code>command.Parameters.Add("@id", DbType.Int32).Direction = ParameterDirection.Output;
  </code></pre>