Hello,

I am using the FTS5 extension for SQLite (System.Data.SQLite.Core.FTS5) for an ASP.Net Core web project. When running on my local machine everything works fine, however, when I deploy to my host, queries no longer work. I suspect the answer has to do with my web.config file: I have reproduced the relevant section below. Has anyone encountered this problem? Any help would be much appreciated. Thanks!

<system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite"/> <add name="SQLite Data Provider" invariant="System.Data.SQLite.Core.FTS5" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.Core.FTS5, System.Data.SQLite.Core.FTS5, Version=1.0.109.1, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data>