Sqlite3 VS System.Data.SQLite

(1) By anonymous on 2024-07-25 12:45:27 [source]

Hey, I had a question regarding sqlite3.dll and System.Data.SQLite.dll, it seems sqlite3 is a native library to interact with SQLite databases, and System.Data.SQLite is a .NET wrapper around the SQLite library, allowing .NET applications to interact with SQLite databases.

My question is do I need Sqlite3 present in my project if I'm using System.Data.Sqlite(1.0.117 version)? I believe it internally uses sqlite3 dll?

I checked other sources it says it uses 3.40.0 sqlite3 version just wanted to confirm.

Thanks.

(2.1) By AAsk1902 on 2024-07-25 13:12:41 edited from 2.0 in reply to 1 [link] [source]

System.Data.SQLite.DLL is statically based on a version of SQLite3.DLL and has NO dependency on SQLite3.DLL i.e. having SQLite3.DLL in your project is of no consequence unless your project is also using the APIs exposed by SQLite3.DLL.

(3.1) By chrisjlocke1 on 2024-07-26 16:48:36 edited from 3.0 in reply to 1 [link] [source]

system.data.sqlite v1.0.117 uses sqlite v3.40.0, and you don't need sqlite3 installed to use system.data.sqlite.

Note v1.0.118 is available which uses sqlite v3.42.0 (available since Jun last year) with v1.0.119 scheduled.