Sqlsugar solve the problem of SQLite access

Sqlsugar with the version is 4.5.9.5, Access sqlite data hint error. In the local debugging for a moment there is no error, the code published to the server after the beginning of the run no problem, a period of time after the error.

Chinese version message:connection open error. Unable to load DLL ' SQLite.Interop.dll ': Operation completed successfully. (Exception from hresult:0x00000000 (S_OK))
Chinese Message: Connection string error, I can't find the reason please first Google error unable to load DLL ' SQLite.Interop.dll ': Operation completed successfully. (Exception from hresult:0x00000000 (S_OK)).

Reference article Address:

Http://www.cnblogs.com/muzhiye/p/4284070.html

Through the above article reference, Sqlsugar with the version is dependent on SQLite.Interop.dll so may often error. So I came down with a System.Data.SQLite.dll that didn't depend on SQLite.Interop.dll.

The System.Data.SQLite.dll version of SQLite used by Sqlsugar is 1.0.102.0

DLLs that do not rely on SQLite.Interop.dll official: http://system.data.sqlite.org/downloads/1.0.102.0/ Sqlite-netfx40-static-binary-bundle-win32-2010-1.0.102.0.zip

After downloading the copy inside System.Data.SQLite.dll replace the DLL with the same name as the bin directory on the server. This does not rely on SQLite.Interop.dll and requires the installation of the Microsoft Visual C + + SP1 Redistributable Package (x64) on the server. It's not easy to make a mistake.

And then it solves my problem.

Sqlsugar solve the problem of SQLite access