Sqlite Connection issue with Azure Function
Lots of Developers might have noticed that SQLite doesn't connect with Azure Function straightforward. You mush have noticed Azure function host complains about missing e_sqlite3.dll . Most noticeable error message: [26/07/2020 10:40:25 AM] Executed 'UpdateMF' (Failed, Id=67777b37-d1ff-4c01-90e3-155e29b9b606) [26/07/2020 10:40:25 AM] Microsoft.Data.Sqlite: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception. System.Private.CoreLib: Exception has been thrown by the target of an invocation. System.Private.CoreLib: Unable to load DLL 'e_sqlite3' or one of its dependencies: The specified module could not be found. (0x8007007E). [26/07/2020 10:40:25 AM] An unhandled host error has occurred. [26/07/2020 10:40:25 AM] Microsoft.Data.Sqlite: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception. System.Private.CoreLib: Exception has been thrown by the target of an invocation. System.Private.Cor...