Today's C# Tip
How to fix "Could not load assembly System.Data.SQLite.dll"
Problem
When I copy a working C# application to another machine, I ran into the following error.
"Could not load assembly System.Data.SQLite.dll or one of its dependencies."
The C# application was using SQLite and looked like some dependencies were missing in that machine.
Solution
In order to figure out what kind of dependencies are missing, I used Dependancy Walker where it showed missing component.
So it turned out that MSVCR110.dll was missing.
MSVCR110.dll is MS C++ Runtime DLL and can be installed from
Microsoft Visual C++ Redistributable 2012.
Install MSVC++ Redist 2012 x86 edition from this link:
https://www.microsoft.com/en-us/download/details.aspx?id=30679
Please note that you might be missing different version of MS C++ Runtime.