How it works...

The goal of this recipe was to accept input values from the user and save them in 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 created a new SQL Database and created firewall rules that allow us to connect remotely from the local development workstation using SSMS. We also created a table named EmployeeInfo, which can be used to save data.

We developed a simple program using the ADO.NET API, which connects to the Azure SQL Database and inserts data into the EmployeeInfo table.