title: How to fix System.Data.SQLite not found when deploying a Visual Studio app with advanced installer?
body: <p>(I apologize for my bad English, I'm a Mexican student)
  I'm trying to deploy an app (using windows forms) which has an installer (Advanced installer ) and using SQLite, when running on Visual Studio works without problem, but when installed I get an &quot;System.Data.SqLite not found&quot;  error, How to fix it to work, explained for a new persons that is learning programing?</p>
  <p>I have tried all the solutions and recommendations of similar questions, but the error keeps popping. I tried to solve it in a W10 64-bit pc.
  Previously I tried with this question <a href="https://stackoverflow.com/questions/1278929/could-not-load-file-or-assembly-system-data-sqlite">Could not load file or assembly &#39;System.Data.SQLite&#39;</a>
  The main difference is that the problem is showed when running in VS, solved by installing through Nu-get or changing some configurations, my problem is only when compiling an .msi installer and installing the app, and that changes doesn't work</p>
  <p>here is the code error, if is not enough tell me and I can share more info</p>
  <pre><code>System.IO.FileNotFoundException: No se puede cargar el archivo o ensamblado 'System.Data.SQLite, Version=1.0.111.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado.
  Nombre de archivo: 'System.Data.SQLite, Version=1.0.111.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'
     en Half_Heart_IDE.db_driver.Start_up(String Adress)
     en Half_Heart_IDE.Form1.Crear_todo(Object sender, EventArgs e)
     en System.Windows.Forms.Control.OnClick(EventArgs e)
     en System.Windows.Forms.Button.OnClick(EventArgs e)
     en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
     en System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons button, Int32 clicks)
     en System.Windows.Forms.Control.WndProc(Message&amp; m)
     en System.Windows.Forms.ButtonBase.WndProc(Message&amp; m)
     en System.Windows.Forms.Button.WndProc(Message&amp; m)
     en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m)
     en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m)
     en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  </code></pre>
  <p>I want to fix it in order to be capable of using SQLite in 64/32bit machines (or creating specific installers) when the app is installed using the .msi generated by Advanced installer 16.1 in VS Community 2019 16.2.0</p>