Edit

Data access in Windows apps

You can store data on the user's device by using a SQLite database. You can also connect a Windows app to a database by using a database client library when the app runs in a controlled environment where direct database access is acceptable.

For enterprise line-of-business apps that access shared data, prefer an authenticated service layer that owns database access. A service boundary helps centralize authorization, validation, auditing, versioning, and credential protection. Don't embed shared database credentials or privileged connection strings in a desktop client.

Topics in this section

In this section, you'll learn how to store and retrieve data in a Windows app by using different back-end databases. Each topic provides a guide to help you get started.

Topic Description
Use a SQLite database on Windows Shows you how to use SQLite to store and retrieve data in a light-weight database on the user's device. SQLite is a server-less, embedded database engine.
Use a SQL Server database in a Windows app Shows you how to connect directly to a SQL Server database and then store and retrieve data by using classes in the Microsoft.Data.SqlClient namespace. Use direct database access only when it fits your deployment and security model.
Use a Cosmos DB database in a Windows app Shows you how to work with a Cosmos DB database and test the connection programmatically. Cosmos DB is a cloud-based document database.
Use a MySQL database in a Windows app Shows you how to connect to a MySQL database and interact with the database in a Windows application. MySQL is an open source, cross-platform relational database.
Use a MongoDB database in a Windows app Shows you how to work with a MongoDB database and test the connection programmatically. MongoDB is a cross-platform document database.

Related content

  • Last updated on