title: SQL.Data.SqlLite version with NHibernate 2.1
body: <p>What version/implementation of the SQLLite can be used with NHibernate. I get an error:</p>
  
  <blockquote>
    <p>The IDbCommand and IDbConnection
    implementation in the assembly
    SQLite.NET could not be found. Ensure
    that the assembly SQLite.NET is
    located in the application directory
    or in the Global Assembly Cache. If
    the assembly is in the GAC, use
     element in the
    application configuration file to
    specify the full name of the assembly.</p>
  </blockquote>
  
  <p>Let me say that dll is in the bin directory, I made sure.
  I am using System.Data.SQLite.DLL version 1.0.60.0.</p>
  
  <p>Here is the hibernate.cfg.xml</p>
  
  <pre><code>    &lt;property name="connection.driver_class"&gt;
          &lt;!--NHibernate.Driver.SqlClientDriver--&gt;
          NHibernate.Driver.SQLiteDriver
      &lt;/property&gt;
       &lt;property name="connection.connection_string"&gt;
          &lt;!--    Server=.\SQLEXPRESS;User Id=epitka;Password=password;Database=dnn49;--&gt;
          Data Source=nhibernate.db;Version=3
    &lt;/property&gt;
    &lt;property name="dialect"&gt;NHibernate.Dialect.SQLiteDialect&lt;/property&gt;
  
    &lt;property name="query.substitutions"&gt;true=1;false=0&lt;/property&gt;
  
    &lt;property name="show_sql"&gt;true&lt;/property&gt;
  </code></pre>
  
  <p>I am running this on Window XP box.</p>