title: How to add SQLite (SQLite.NET) to my C# project
body: <p>I followed the instructions in the documentation:</p>
  
  <blockquote>
    <p><em>Scenario 1:  Version Independent (does not use the Global Assembly Cache)</em> </p>
    
    <p>This method allows you to drop any new
    version of the System.Data.SQLite.DLL
    into your application's folder and use
    it without any code modifications or
    recompiling.  Add the following code
    to your app.config file:</p>
  </blockquote>
  
  <pre><code>&lt;configuration&gt;
    &lt;system.data&gt;
      &lt;DbProviderFactories&gt;
        &lt;remove invariant="System.Data.SQLite"/&gt;
        &lt;add name="SQLite Data Provider" invariant="System.Data.SQLite"
             description=".Net Framework Data Provider for SQLite"           type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /&gt;
      &lt;/DbProviderFactories&gt;
    &lt;/system.data&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>My app.config file now looks like this:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;configuration&gt;
      &lt;configSections&gt;
          &lt;sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" &gt;
              &lt;section name="DataFeed.DataFeedSettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /&gt;
          &lt;/sectionGroup&gt;
      &lt;/configSections&gt;
      &lt;userSettings&gt;
          &lt;DataFeed.DataFeedSettings&gt;
              &lt;setting name="eodData" serializeAs="String"&gt;
                  &lt;value&gt;False&lt;/value&gt;
              &lt;/setting&gt;
          &lt;/DataFeed.DataFeedSettings&gt;
      &lt;/userSettings&gt;
      &lt;system.data&gt;
        &lt;DbProviderFactories&gt;
          &lt;remove invariant="System.Data.SQLite"/&gt;
          &lt;add name="SQLite Data Provider" 
               invariant="System.Data.SQLite"
               description=".Net Framework Data Provider for SQLite" 
               type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /&gt;
        &lt;/DbProviderFactories&gt;
      &lt;/system.data&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>My project is called "DataFeed":</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using System.Data.SQLite; //&lt;-- Causes compiler error
  
  namespace DataFeed
  {
      class Program
      {
          static void Main(string[] args)
          {
          }
      }
  }
  </code></pre>
  
  <p>The error I get is:</p>
  
  <blockquote>
    <p>.\dev\DataFeed\Program.cs(5,19):
    error CS0234: The type or namespace
    name 'SQLite' does not exist in the
    namespace 'System.Data' (are you
    missing an assembly reference?)</p>
  </blockquote>
  
  <p>I'm prefer not to use the GAC so I simply dropped the <code>System.Data.SQLite.dll</code> into my <code>.\dev\DataFeed\</code> folder. I thought that all I needed to do is add the DLL to the project folder as it was mentioned in the documentation, but I can't use the library. Any hints on how to actually make this work?</p>