Episode

Build mobile and desktop apps with .NET MAUI Ep07: Store local data with SQLite in a .NET MAUI app

with James Montemagno, Matt Soucoup, Frank Boucher

Learn Live

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:40 - Learning objectives
  • 10:06 - Compare storage options
  • 20:32 - The file system
  • 21:40 - Access the app sandbox
  • 25:08 - Guidelines for saving data in iOS apps
  • 29:08 - Knowledge check
  • 36:44 - Store data locally with SQLite
  • 37:43 - When to use a database
  • 39:05 - What is SQLite-net?
  • 40:52 - How to connect to a SQLite database
  • 44:00 - Model a SQLite table
  • 48:00 - How to do basic read and write operations
  • 50:33 - Execute a SQLite query by using LINQ
  • 52:55 - Exercise - Store data locally with SQLite
  • 01:18:04 - Exercise - Use SQLite asynchronously
  • 01:23:18 - Summary and conclusion

Connect

Beginner
Developer
Student
.NET
.NET MAUI
Visual Studio