litereplica

.NET

There are many options:

System.Data.SQLite

We need to install the dependencies (Binn and nanomsg), replace the the SQLite code and then compile the module. Here are the steps:

1. Download the pre-compiled binaries, or compile Binn and nanomsg

2. Copy binn-1.0.dll and nanomsg.dll to the Windows\SystemWOW64 or Windows\System32 folder

3. Copy the files in the include folder to the include folder from Visual Studio (eg. C:\Program Files\Microsoft Visual Studio 10.0\VC\include)

4. Copy the .lib files to the lib folder of Visual Studio (eg. C:\Program Files\Microsoft Visual Studio 10.0\VC\lib)

5. Download the System.Data.SQLite source-code and replace the files at /SQLite.Interop/src/core folder for those that come with litereplica (sqlite3.c + sqlite3.h).

6. Open in Visual Studio and compile it.

If you are testing with the GPL'd version of litereplica then use this version because it uses the SQLite 3.8.11.

If you have the litereplica commercial license then you can use the last version of System.Data.SQLite.

SQLite.NET

The SQLite.NET engine interfaces with the installed sqlite3 library as we can see here.

So we can compile and install litereplica using the normal and default library name (sqlite3.dll on Windows) and then open the database with SQLite.NET using a URI.

Mono SQLite

The Mono SQLite engine interfaces with the installed sqlite3 library.

We can compile and install litereplica using the normal and default library name (sqlite3.dll on Windows).

For the interface to work with the right library we must define SQLITE_STANDARD and expect that MONOTOUCH is not defined, as we can see here.

Microsoft.Data.SQLite

The Microsoft.Data.SQLite engine comes with the ASP.Net Core. It also interfaces with the installed sqlite3 library.

So we can compile and install litereplica using the default library name sqlite3.dll or winsqlite3.dll, as we can see here.