sql logic error or missing database
The specified procedure could not be found.

这是我的代码：

sqliteConnection connection = (sqliteConnection)session.Connection;
connection.EnableExtensions(true);
Assembly assembly = Assembly.Load("System.Data.sqlite");
connection.LoadExtension(assembly.Location,"sqlite3_json_init");

我正在使用NHibernate,所以我只是在执行任何逻辑之前从会话中获取连接.

有什么我做错了吗？我也尝试加载sqlite.Interop.dll,然后调用sqlite3_json_init方法,但仍然无法正常工作.

我做了这个,它似乎仍然没有工作：

sqliteConnection connection = (sqliteConnection)session.Connection;
                connection.EnableExtensions(true);
                string path = "F:\\GitHub\\ExampleProj\\lib\\sqlite\\sqlite.Interop.dll";
                if (File.Exists(path))
                {
                    connection.LoadExtension(path,"sqlite3_json_init");
                }