Using ExcelDNA and System.Data.SQLite

I have no issues using ExcelDNA and I also have no issues using System.Data.SQLite in a standalone exe. Howover I have not been able to make both work together for creating an Excel Addin dll (using Visual Studio 2012 and NuGet to install the SQLite .NET package) to be used to query an SQLite database. From my troubleshooting it appears some SQLite dependencies are not getting resolved properly. I am still waiting to see if I can get any help from the SQLite user group mailing list, however was wondering if anyone here would have successfully used both together and if there are some gotchas I don't know. I am using the Northwind SQLite database for this test.

The stack trace given below, if at all it helps.

Thank you so much for looking at this post! :-)