title: Mono + SQLite + Dapper SQLite Exception during Insert
body: <p>I am using Mono, SQLite, Dapper &amp; Dapper Extensions. I can read from the database but Insert is not working. I am using Mono Driver for sqlite. </p>
  
  <p>Error is not very informative, atleast to me. Any help will be much appreciated.</p>
  
  <p>Error: </p>
  
  <pre><code>SQLite error
  near ".": syntax error
  at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, UInt32 timeoutMS,    System.String&amp; strRemain) [0x00000] in &lt;filename unknown&gt;:0 
  at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000] in &lt;filename unknown&gt;:0
  </code></pre>
  
  <p>Test code:</p>
  
  <pre><code>public void can_add_a_service_record()
      {
          var provider = new Provider { Name = "Hotmail" };
          int id = providerData.Insert(provider);         
          Assert.AreEqual("Hotmail", providerData.Get(id).Name);  
      }
  </code></pre>
  
  <p>The code for insert is as follows.</p>
  
  <pre><code>public virtual int Insert (TEntity entity)
      {
          var connection = SqlHelper.GetConnection();         
          int id = connection.Insert&lt;TEntity&gt;(entity);
          connection.Close();
          return id;
      }
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Chirdeep</p>