Install the Dapper and SQLite NuGet packages In this example, we’ll use Dapper to connect to and work with a SQLite database.

If you understand SQLite "Select" commands you can tailor them to retrieve specific data from any table. Type .help at the SQLite prompt to view other commands that can help you manage your database.

Whether you want some quick and dirty data storage, or simply don’t have that heavy requirements for your local database system, SQLite is always a good choice. With its portable single-file ...