In this post, we will install the SQLiteStudio on Windows operating system. SQLiteStudio is desktop application for browsing and editing SQLite database files.
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.
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.