First of all we need to add SQLite support to our application. There are two ways of doing that
Download DLL suiting your system from SQLite download page and then add to the project manually
Add SQLite dependency via NuGet
We'll do it the second way
First open the NuGet menu
and search f...
using (SQLiteConnection conn = new SQLiteConnection(@"Data Source=data.db;Pooling=true;FailIfMissing=false"))
{
conn.Open();
using (SQLiteCommand cmd = new SQLiteCommand(conn))
{
cmd.CommandText = "query";
using (SqlDataReader dr = cmd.ExecuteReade...
