CustomAction failed-"Unable to load DLL 'SQLite.Interop.dll':The specified module could not be found.(ExceptionHRESULT: 0x8007007E)"

I am trying to access the database from a custom action.However the connection is failing with a message "Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)".I want to know that where does a custom action looks for the SQLite.Interop.dll,while connecting to the database from within a custom action.The SQLite.Interop.dll is present in my install folder after installation as I have added it as a component in the product.wxs.

To give you a hint Sqlite.Interop.dll are under x86 and x64 folders and somehow Wix does not pick up subfolders under the CustomAction's bin folder. You need to somehow have these two folders install under C:\Windows\Installer\xxxxxfolder where you custom actiondllfiles are copied during install. The problem I am having is that I cannot find the variable for that temp folder underC:\Windows\installer(that is different thanC:\User\Temp...`).

Reference: Program Unable to Load DLL 'SQLite.Interop.dll' after WiX Installation