title: Insert data into sqlite in-memory database
body: <p>So I have a in-memory database and I'm trying to insert data into the table and it's not working. Am I doing something wrong?</p>
  
  <pre><code>var connection = new SQLiteConnection("DataSource=:memory:;Version=3;New=True;");
  
  connection.Open();
  
  string sql = "CREATE TABLE  recently_viewed(movieid INTEGER,picture TEXT)";
  
  SQLiteCommand command = new SQLiteCommand(sql, connection);
  command.ExecuteNonQuery();
  
  using ( command = connection.CreateCommand())
  {
      command.CommandText = "INSERT into recently_viewed(movieid ,picture) values(@movieid,@picture)";
      command.Prepare();
      command.Parameters.AddWithValue("@movieid", id);
      command.Parameters.AddWithValue("@picture", picture);
  }
  
  string   count_table = " SELECT count(*) FROM recently_viewed";
  
  SQLiteCommand   com3 = new SQLiteCommand(count_table, connection);
  
  int   ctable = Convert.ToInt32(com3.ExecuteScalar().ToString());
  
  Response.Write(ctable);
  
  connection.Close();
  </code></pre>