SQLite: no such module: fts5 error with System.Data.SQLite.dll 1.0.101.0

Question

I am using System.Data.SQLite.dll 1.0.101.0 and I get this error when execute the command "CREATE VIRTUAL TABLE tbl_fts USING fts5 (fld1, fld2)".

error: no such module: fts5

in this page we can see: 1.0.99.0 - December 9, 2015

•Add experimental support for the native json1 and fts5 extensions

https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki

so what is the problem, and how can I enable fts5, should I rebuild System.Data.SQLite.dll? how can I do that?

thanks..

Answer 1

here the solution, more than 6 hours of work until found it:

    MyConnection.EnableExtensions(True)
    MyConnection.LoadExtension("System.Data.SQLite.dll", "sqlite3_fts5_init") ''/// Or "SQLite.Interop.dll" as you need.

I understood that by this sentence: "Add experimental support for the FTS5 loadable extension. (user: mistachkin)"

http://system.data.sqlite.org/index.html/finfo?name=SQLite.Interop/SQLite.Interop.2010.vcxproj