Using SQLite in C# - Building Simple, Powerful, Portable Databases for Your Application

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: https://www.iamtimcorey.com/p/sqlite-from-start-to-finish
Source Code: https://leadmagnets.app/?Resource=SQLiteInCSharp
Patreon: https://patreon.com/IAmTimCorey
Newsletter signup: https://signup.iamtimcorey.com/

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

Видео Using SQLite in C# - Building Simple, Powerful, Portable Databases for Your Application канала IAmTimCorey