3 Using database and storage components
This chapter covers
- Connecting Aspire to an existing database instance using connection strings
- Integrating SQL Server and consuming data with both raw SQL and Entity Framework.
- Working with other relational databases, including Oracle, PostgreSQL, and MySQL
- Using NoSQL databases such as MongoDB and Azure Cosmos DB
- Connecting to Azure Storage services such as Table Storage and Blob Storage
Aspire can be integrated with many database types, including SQL-based relational database management systems (RDBMS) and various categories of NoSQL databases, such as document stores and key-value stores. All this can be done via Aspire integration libraries.
This chapter covers both database categories, with examples showing a range of specific data storage technologies in SQL and NoSQL areas. Before we start, however, let’s talk about connecting Aspire to an existing database instance. We'll do so by continuing to build our e-commerce app. Our app needs data, such as the products we sell, the orders customers place, and so on. This is what databases are for.
3.1 Connecting Aspire to an existing database
Before we look at how to build database resources and let the Aspire host manage them, let's look at how to connect Aspire instances to existing resources. After all, we may already have a fully managed instance of a SQL Server, Oracle, or MongoDB database that we want to connect our system to.