title: How to use System.Data.SQLite under mono?
body: <p>I downloaded <a href="http://sqlite.phxsoftware.com/" rel="noreferrer">System.Data.SQLite</a>, and tried to compile the following sample code. </p>
  
  <pre>
  using System;
  using System.Data;
  using System.Data.Common;
  using System.Data.SQLite;
  
  namespace test
  {
    class Program
    {
      static void Main(string[] args)
      {
        SQLiteConnection.CreateFile("/Users/smcho/Desktop/SQLite-1/example/mydatabasefile.db3");
      }
    }
  }
  </pre>
  
  <p>I ran the following command</p>
  
  <pre>
  mcs db.cs -r:System.Data.dll -r:System.Data.SQLite.dll
  </pre>
  
  <p>But, I got the error messages as follows.</p>
  
  <pre>
  ** (/opt/local/lib/mono/1.0/mcs.exe:43249): WARNING **: The class System.Data.Common.DbConnection could not be loaded, used in System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
  db.cs(12,7): error CS0103: The name `SQLiteConnection' does not exist in the current context
  Compilation failed: 1 error(s), 0 warnings
  </pre>
  
  <p>What might be wrong? </p>