System.DllNotFoundException: Unable to load DLL 'System.Data.SQLite.DLL': (Exception from HRESULT: 0x8007045A)

Getting error: System.DllNotFoundException: Unable to load DLL 'System.Data.SQLite.DLL': A dynamic link library (DLL) initialization routine failed. (Exception from HRESULT: 0x8007045A)

The exe was being run through script in YAML pipeline. The DLL was placed in the same folder as exe

System.Data.SQLite require the appropriate version (e.g. 2005, 2008, 2010, 2012, 2013, 2015, 2017) of the Microsoft Visual C++ Runtime Library, to be successfully installed on the target machine, prior to making use of the executables contained therein.

Refer https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki and install appropriate setup of VC runtime.