title: SQLite basic example
body: <p>I am trying to create a database with SQLite with c# then create a table insert data then close the connection. I have just downloaded System.Data.SQLite.dll lybrary and I am not sure how to use it. There are a lot of examples in the internet but all of them seem to have a database already. Or maybe I am doing something wrong. </p>
  
  <p>It will be nice If I can have a short example to just create a database, table and basic query.</p>
  
  <p>EDIT</p>
  
  <p>I have tried the examples provided by the comments but I don't understand why I do get errors. Maybe I downloaded the wrong library? 
  <img src="https://i.stack.imgur.com/ILH1q.png" alt="enter image description here"></p>