I am writing a Console App on Net Core 2.0. My App uses NHibernate Fluent to work with SQLite local db. However when running the code below here, I get the following errors:

Could not create the driver from NHibernate.Driver.SQLite20Driver

The DbCommand and DbConnection implementation in the assembly System.Data.SQLite could not be found. Ensure that the assembly System.Data.SQLite is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use element in the application configuration file to specify the full name of the assembly.

I have installed System.Data.SQLite from Nuget. Why do I have the following error?

Original post on the stackoverflow:

NHibernate.Driver.SQLite20Driver has the following code:


P.S: everything was working fine with System.Data.SQLite.Core 1.0.108 but it was windows only compatible.

How can I make it work with the SQLite dll which is compatible with .net core 2.0