cognitiveServiceEndpoint

cognitiveServiceKey

storageAccountConnectionString

SQL Server connection string obtained when created Storage Account

sqlServerConnectionString

SQL Server connection string obtained when created SQL Server

Learn foundational Microsoft Azure concepts and develop essential skills as a C# developer. This course covers AI, hosting, storage, and monitoring services to build basic Azure solutions.

tarball.tar.gz

subscriptionId

location

resourceGroup

appServicePlan

appService

gitrepo

functionApp

functionAppStorageAccount

storageAccountName

keyVaultName

keyVaultSecretName

cognitiveServiceName

applicationInsightsName

sqlServerName

sqlDbName

sqlServerUsername

sqlServerPassword

Username

Password

PostmanUsername

deploymentAppServicePlanName

deploymentFunctionAppName

CSharp-SPA-CognitiveService

postman

chapter 3 postman2

This beginner-level course targets C# developers who want to develop their Microsoft Azure skills. It provides foundational knowledge of the key Microsoft Azure concepts needed for every developer and explains foundational services used in the AI, hosting, storage, and monitoring areas. 

After completing this course, you’ll be familiar with foundational Microsoft Azure concepts and will be able to build basic Microsoft Azure solutions.

Master Azure: Build Microsoft Azure Solution with C#

# Preparing the code

Now that we’ve created our database and table where we’ll store the data, it’s time to modify our API to store the image description data in the database.

- First, we need to add a project reference to the SQL Client to enable us to interact with the Azure SQL server from our code. In the `.csproj` file, we will add the following package reference:

We will add a new function to the `ImageDescriberApi.cs` file, as illustrated in the code below.
> **Note:** The `{{sqlServerConnectionString}}` placeholder will be replaced by the actual database connection string saved earlier, provided in the `sqlServerConnectionString` environment variable.

Update the code to support saving image data to the Azure SQL database.

Updating the Code to Store in Microsoft Azure SQL Database

Introduction to Microsoft Azure

Key Microsoft Azure Services for Developers

Building Your First Microsoft Azure Solution

Wrap Up

Appendix

Updating the Code to Store in Microsoft Azure SQL Database