In this post, we will create a chatbot that connects to the local SQL Database. This will be a simple customized bot that can be used for any use case. We will implement two CRUD operations READ and INSERT.
Before going to Bot framework connection to DB, we will learn how to Insert data to Local SQL Database using Entity Framework. The concept will be the same for Microsoft Bot Framework.
In this post, we will create a chatbot that connects to both the QnA Maker service and Azure SQL DB. This will be a simple customized bot that can be used for any use case.
Here we will be updating the SQL Database with data coming as a response from an API using Power Automate. Automate business processes, connect to almost 300 data sources and publicly available API.
Azure SQL Database is the intelligent, scalable, relational database service built for the cloud. It is evergreen and always up to date, with AI-powered and automated features that optimise performance and durability for you.
This is part 2 of the series “Connect Microsoft Bot Framework to Database“. In the last part, we have used Entity Framework to connect to the DB. In this part, we will use the same Entity Framework inside the Bot Framework to connect the bot with the local DB.