title: SQLite.Net Issue With BeginTransaction
body: <p>I'm trying to use System.Data.Sqlite library, and I'm following the documentation about optimizing inserts so I copied this code directly out of the documentation:</p>
  
  <pre><code>  using (SQLiteTransaction mytransaction = myconnection.BeginTransaction())
    {
      using (SQLiteCommand mycommand = new SQLiteCommand(myconnection))
      {
        SQLiteParameter myparam = new SQLiteParameter();
        int n;
  
        mycommand.CommandText = "INSERT INTO [MyTable] ([MyId]) VALUES(?)";
        mycommand.Parameters.Add(myparam);
  
        for (n = 0; n &lt; 100000; n ++)
        {
          myparam.Value = n + 1;
          mycommand.ExecuteNonQuery();
        }
      }
      mytransaction.Commit();
    } 
  </code></pre>
  
  <p>Now, I initialize I connection right before that by using </p>
  
  <pre><code>SqlConnection myconnection = new SqlConnection("Data Source=blah");
  </code></pre>
  
  <p>I have a Database named blah, with the correct tables and values.</p>
  
  <p>The problem is when I run this code, it says "Operation is not valid due to the current state of the object"</p>
  
  <p>I've tried changing the code around several times, and it still points to BeginTransaction.  What gives?</p>