Trigger function based on queue storage on Azure function. Establish connection to the sql server database and execute sql query statement.
- Go to azure function > Platform features > Under development tools, select Advance tools (Kudu).
- On the option header, choose Debug console dropdown > CMD
- Select (+) sign on the root directory to create a new file/folder
- Upload the file to the desire folder
- Test and run the function
- ......
- Profit!
- create a connection string in azure function app. put your credential information as well as database server endpoint
var str = ConfigurationManager.ConnectionStrings["sqldb_Gorgias" ].ConnectionString;