Learn Live – Store local data with SQLite in a .NET MAUI app

Microsoft Developer

Full series information: https://aka.ms/learnlive-mobile-desktop-apps-dotnet-maui

More info here: https://aka.ms/learnlive-mobile-desktop-apps-dotnet-maui-Ep7

Follow on Microsoft Learn:

– Microsoft Learn Module: https://aka.ms/learnlive-20221116A

Learn how to store and access data held in SQLite using a .NET MAUI app

———————

Learning objectives

– Compare the different data storage options that are available for .NET MAUI applications
– Store relational data in a SQLite database
– Interact with your database asynchronously to make sure that your UI remains responsive

———————

Chapters
——–
00:00 – Introduction
06:20 – Learning objectives
09:46 – Compare storage options
20:12 – The file system
21:20 – Access the app sandbox
24:48 – Guidelines for saving data in iOS apps
28:48 – Knowledge check
36:24 – Store data locally with SQLite
37:23 – When to use a database
38:45 – What is SQLite-net?
40:32 – How to connect to a SQLite database
43:40 – Model a SQLite table
47:40 – How to do basic read and write operations
50:13 – Execute a SQLite query by using LINQ
52:35 – Exercise – Store data locally with SQLite
1:17:44 – Exercise – Use SQLite asynchronously
1:22:58 – Summary and conclusion

———————

Presenters

Matt Soucoup
Principal Cloud Developer Advocate for .NET
Microsoft
– Twitter: https://twitter.com/CodeMillMatt
– LinkedIn: https://www.linkedin.com/in/msoucoup/

Frank Boucher
Senior Cloud Advocate
Microsoft
– Twitter: https://twitter.com/fboucheros
– LinkedIn: https://www.linkedin.com/in/fboucheros/

Moderators

Jon Galloway
Senior Program Manager
Microsoft
– Twitter: https://twitter.com/jongalloway