Below I describe how to configure C# .net application to work with SQLite database client.
First download and install sqlite ado.net provider. Then include to your project configuration below settings:
Add to project references files:
SQLite.Designer
System.Data.SQLite
System.Data.SQLite.Linq
and set property 'Copy Local' value equal true for each of them.
Enjoy.