In this post, we will install the SQLiteStudio on Windows operating system. SQLiteStudio is desktop application for browsing and editing SQLite database files.
Download and Install SQLiteStudio
Connect Bot Framework to DB | READ and INSERT Data to Local SQL DB
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.
Share this:
Connect Bot Framework to DB | INSERT Data to DB using Entity Framework
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.
Share this:
Connect Bot Framework to DB [Part 2] | READ Data from Local SQL Database
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.
Share this:
Connect Bot Framework to DB [Part 1] | READ data from DB using Entity Framework
Entity Framework Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with many databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB.
![[Fixed] The operation "List" is not enabled in this key vault's access policy](https://i0.wp.com/jd-bots.com/wp-content/uploads/2021/07/image-117.png?fit=912%2C248&ssl=1&resize=40%2C40){kind=small}
![[Fixed] Cannot see Repos in Azure DevOps with Stakeholder Access](https://i0.wp.com/jd-bots.com/wp-content/uploads/2021/08/image-97.png?fit=985%2C516&ssl=1&resize=40%2C40){kind=small}
![[Fixed] 'ConfigurationBuilder' does not contain a definition for 'SetBasePath'](https://i0.wp.com/jd-bots.com/wp-content/uploads/2022/01/image-45.png?fit=692%2C430&ssl=1&resize=40%2C40){kind=small}
You must be logged in to post a comment.