Introduction
When you're building mobile applications, it's common to store data locally on a device for performance reasons. .NET Multi-platform App UI (MAUI) allows you to cache data locally on the device on which the application is running. You can store this data using several different technologies. To store relational data, you can use a SQLite database.
Suppose you're building a social-media application that lets users connect with each other. Because the data about users is stored remotely, you have to call the REST endpoint to get information about the users with which you're connected every time you restart the application.
This design works. However, it's inefficient, because you have to keep downloading the user information from the server every time you restart the application.
A more efficiently designed app downloads the user data once and saves it locally to the device. With this design, you only have to download information for other users when you want to make a new connection. You can create this more efficient design by using a local database.
In this module, you build a .NET MAUI application that stores data locally in a database. You start by exploring the different data-storage options that are available.
Next, you look at SQLite and learn how to insert and retrieve data. Finally, you use the asynchronous methods available in SQLite to interact with the database without blocking the UI.
By the end of this module, you're able to build a .NET MAUI application that stores data locally in a SQLite database.
Learning objectives
In this module, you learn how to:
- Compare different data storage options that are available for .NET MAUI applications.
- Store relational data in a SQLite database.
- Interact with a database asynchronously to make sure that your UI remains responsive.
Prerequisites
- Visual Studio 2022 with the .NET MAUI workload installed
- Optional: Visual Studio Code with the .NET MAUI Extension and .NET SDK with the .NET MAUI workload installed
- Familiarity with C# and .NET
- Basic knowledge of SQL and relational databases
Requirements for .NET MAUI development
To create .NET MAUI apps with .NET 9, you need to install Visual Studio version 17.12 or newer with the following workload installed:
- .NET Multi-Platform App UI development
Additionally, if you want to build .NET MAUI Blazor apps, you must install the ASP.NET and web development workload.
See the documentation for a walkthrough of setup.
Development with Visual Studio Code
If you're developing on macOS or Linux, you'll need to install Visual Studio Code and the .NET MAUI Extension along with the .NET SDK and .NET MAUI Workload. See the documentation for a walkthrough of setup.