CODEWITHSUNDEEP
c#sqlite
J. Doe
J. Doe

Reputation: 1327

Working with Sqlite.dll error

I am trying to make a small application, working with SQLite. However I am running into problems whose solutions on the Net are horribly outdated and nothing I tried works, currently I feel like I have no idea what I am doing.

My problem:

Can't add a reference to SQLite.dll "A reference to sqlite3.dll could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component."

What I've tried:
As far as I know in order to use SQLite in C# code I need to add a reference to an SQLite.dll. I went to the Downloads page of SQLite and downloaded precompiled binaries for Windows (mainly because I have no idea what any of those things are). That didn't work, searched on the 'Net:

The only *.dll I could get going was from a Codeproject example which had a sqliteNet.dll file (I have no idea from where) but that had other problems.

From what I looked for all the information/questions/tutorials about SQLite on the Net are horribly outdated and are no help to me.

Currently I am literally lost and have NO idea why it doesn't work and what I should do, please someone help me!

Upvotes: 0

Views: 484

Answers (2)

Tom Söhne
Tom Söhne

Reputation: 522

can you use the nuget package for sqlite "System.Data.SQLite"?

Since you need a wrapper to the c-dll you should try some nuget package that wraps it already.

Upvotes: 1

user1773603
user1773603

Reputation:

If you haven't tried this method then you have to test it.

  • Right Click on your Project
  • Click on Manage NuGet Packages..
  • In Browse tab search System.Data.SQLite & select it
  • On Right side click on Install button
  • After installing you can use it

Upvotes: 0

Related Questions