Book Image

Building Bots with Microsoft Bot Framework

By : Kishore Gaddam
Book Image

Building Bots with Microsoft Bot Framework

By: Kishore Gaddam

Overview of this book

Bots help users to use the language as a UI and interact with the applications from any platform. This book teaches you how to develop real-world bots using Microsoft Bot Framework. The book starts with setting up the Microsoft Bot Framework development environment and emulator, and moves on to building the first bot using Connector and Builder SDK. Explore how to register, connect, test, and publish your bot to the Slack, Skype, and Facebook Messenger platforms. Throughout this book, you will build different types of bots from simple to complex, such as a weather bot, a natural speech and intent processing bot, an Interactive Voice Response (IVR) bot for a bank, a facial expression recognition bot, and more from scratch. These bots were designed and developed to teach you concepts such as text detection, implementing LUIS dialogs, Cortana Intelligence Services, third-party authentication, Rich Text format, Bot State Service, and microServices so you can practice working with the standard development tools such as Visual Studio, Bot Emulator, and Azure.
Table of Contents (10 chapters)

Storing the bot conversation (new account info) data in an Azure SQL database

We are maintaining the state or bot conversation of the user. For this, we will use an Azure SQL database. We save all the transactions that the user performs, such as registering a new user, credit card payments, checking their balance, and so on. These are the steps for storing the bot conversation in the Azure SQL database:

  1. In the Azure portal, create a new Azure SQL database. To see how to create a new SQL database in Azure, follow the steps shown at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-create-databases.
  2. After the successful creation of a database in Azure, you have to create a table in it. For that, you have to open your SQL database in Visual Studio 2015.
  3. Next, create a table using the following commands:
    CREATE TABLE [dbo].[Accountant_Information] (
[Id] NVARCHAR (128...