How to install System.Data.Sqlite

I am using Visual Studio 2010. I am trying to install the Sqlite framework here . I've installed the precompiled binary for Windows, but in Visual Studio there is no System.Data.SQLite. I've also added a configuration file with this:

<configuration>
<system.data>
    <DbProviderFactories>
        <remove invariant="System.Data.SQLite" />
        <add name="SQLite Data Provider" 
             invariant="System.Data.SQLite" 
             description=".Net Framework Data Provider for SQLite"
             type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>
</system开发者_开发知识库.data>

I still cannot import the library. I'm not sure how to get this working. In XCode I would simply drag the source files for the wrapper into the project, and add my sqlite db. Not so easy here I guess. Also, on the Mac I usually create my db structure through the bash shell using SQLite3. How can I do this on Windows too?

O.o I have used the codeplex Sqlite version and this woks fine for me :D

I suggest you go for the older version from the original website. It comes with an installer that solves all the configuration headaches for you. I only used it in VS 2008 though, there it worked flawlessly.

Add reference from nuget packages (search for sqlite online in nuget manager).

You need to browse for the reference after the setup package is installed: Solution Explorer, rigth click references, add reference, browse, and then select the system.data.sqlite.dll.

Hope this helps.