The goal of this recipe was to accept input values from the user and save them to a relational database where the data could be retrieved later for operational purposes. For this, we used Azure SQL Database, a relational database offering also known as database as a service (DBaaS). We have created a new SQL Database and created firewall rules that allow us to connect remotely from the local development workstation using SSMS. We have also created a table named EmployeeInfo, which can be used to save data.
We have developed a simple program using the ADO.NET API that connects to the Azure SQL Database and inserts data into the EmployeeInfo table.