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

Video Description

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): https://www.iamtimcorey.com/salespage.html?course=ba-slt-01 Source Code: https://www.iamtimcorey.com/downloads/?code=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