You're reading from A Developer's Guide to .NET in Azure Build quick, scalable cloud-native applications and microservices with .NET 6.0 and Azure

Product type Paperback

Published in Oct 2023

Publisher Packt

ISBN-13 9781837633012

Length 504 pages

Edition 1st Edition

Languages

Python

Tools

.NET

Concepts

Cloud Computing

Authors (2):

Tamir Al Balkhi

Anuraj Parameswaran

View More author details

Table of Contents (20) Chapters

Preface

1. Part 1: An Introduction to Your Environment

2. Chapter 1: Setting Up Your Development Environment FREE CHAPTER

3. Part 2: Serverless and Microservices

4. Chapter 2: Creating Docker Containers on Azure

5. Chapter 3: Building Resilient Applications with Dapr

6. Chapter 4: Designing Microservices with AKS and Containers in Azure

7. Chapter 5: Building Serverless Apps with Azure Functions and Container Apps

8. Part 3: Data and Storage

9. Chapter 6: Exploring Azure Blob Storage

10. Chapter 7: Creating an Azure SQL Database

11. Chapter 8: Creating Documents via .NET for Azure Cosmos DB

12. Part 4: Messaging Mechanisms and Security

13. Chapter 9: Utilizing Azure App Configuration

14. Chapter 10: Processing Data with Azure Event Hubs

15. Chapter 11: Designing Ready-Made Solutions with Azure Service Bus

16. Chapter 12: Enhancing Data Protection with Azure Key Vault

17. Chapter 13: Managing Access with Azure Active Directory B2C

18. Index

Why subscribe?

19. Other Books You May Enjoy

Configuring security in Azure SQL Database

In an earlier section, we learned about connecting to Azure SQL Database with ASP.NET Core code. In this section, we will learn about various ways to configure security in Azure SQL Database.

We will look at two main options. First, we will look into how to connect to Azure SQL using an identity and then we will look into firewall configuration.

Connecting to Azure SQL Server using an identity

In an earlier section, we connected to Azure SQL Server with a username and password, but Microsoft’s recommended option to connect to Azure SQL is using identities – a feature that allows services to interact with each other without credentials. There are two types of identities available in Azure. The first one is system-assigned and the second one is user-assigned. System-assigned identities are removed when you remove the associated resource, which means that if we are creating a system-assigned identity for an Azure app service...