SQL, Azure Cosmos DB, and Azure Storage
Earlier, we talked about the broader classification of data stores into RDBMSes and NoSQL. In this section, let's get into the details of some of the data providers available in the Microsoft ecosystem and their integration with .NET 5. There is a wide variety of providers, including SQL, Azure Cosmos DB, and Azure Storage, and the selection of data providers is completely driven by the application needs. However, in real life, application requirements evolve quite a bit, hence the key is to abstract your data framework implementation with the business layer and UI, which further helps in evolving the design as required. With that, let's look at our first data provider, SQL, in the next section.
SQL Server
One of the dominant databases in the RDBMS market is Microsoft SQL Server, popularly known as SQL Server, which uses SQL to interact with the database. SQL Server supports all the RDBMS-based entities, such as tables, views...