Recently, I am working on an asp.net application for my customer, which uses System.Data.SQLite.dll library, when almost finished the project, I upload the application to the Godaddy asp.net hosting, then I got the following error,
Parser Error Message: Could not load file or assembly ‘System.Data.SQLite, Version=126.96.36.199, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)
After some searching, I got the answer, because System.Data.SQLite.dl use dynamic library sqlite3.dll.
I know there exists a Managed SQLite project on google code, but I am not sure it can solve my problem, maybe I had better use mssql.
ManagedSQLite is a managed implementation of the public domain relational database SQLite.
Currently, ManagedSQLite works with Microsoft Visual C# 2005, Microsoft Visual Basic 2005 and Microsoft Visual C++ 2005.
Unlike other managed wrappers for SQLite, ManagedSQLite only requires its own DLL with no need for the SQLite DLL file – reducing the risk of DLL Hell.