Have you ever wanted to store data for an application but didn't want to deal with the hassle of a full database server? Or maybe you wanted to have one database per installation. Those and many other scenarios are a perfect fit for SQLite. Today I am going to show you how to get started using SQLite in C#. We will build a small database, attach it to a C# project, and then wire up our project to read from and write to the database.
SQLite From Start to Finish course (now renamed to Bill Time): [ Ссылка ]
Source Code: [ Ссылка ]
Patreon: [ Ссылка ]
Newsletter signup: [ Ссылка ]
Thanks to Ralfs HBK for the chapter breakdown:
0:00 - Intro
1:14 - Demo app overview (win form app)
4:30 - What is SQLite
5:09 - How to create and build SQLite Database: DB Browser for SQLite
11:17 - Database Structure
13:04 - Adding the Database to the project
15:26 - Adding the Connection string
18:15 - SQLite and Dapper NUGet packages
21:58 - Data access setup
28:17 - Retrieving data form DB: LoadPeople()
30:14 - Sending data to DB: SavePerson()
31:51 - Wiring up the Demo app
33:08 - Workings with the Database
36:18 - Summary and concluding remarks
