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.