If you liked our content and it was helpful, you can buy us a coffee or a pizza.

Thank you All!!! Hope you find this useful. Voila!! There we have our ChatBot using Azure DB. You have entered the live chat and get the details of the employee by entering the employee id. Paste the URL and click on Connect after which you will get the below screen. Go to Bot Framework Emulator and click on Open Bot and paste the URL in the space provided. If (member.Id != )ДЄwait turnContext.SendActivityAsync(MessageFactory.Text(welcomeText, welcomeText), cancellationToken) Var welcomeText = 'Hello and welcome! I have connected this bot to Azure DB.' //welcome message Protected override async Task OnMembersAddedAsync(IList membersAdded, ITurnContext turnContext, CancellationToken cancellationToken) Var replyText = employee.Empid + ': ' + employee.Empname ДЄwait turnContext.SendActivityAsync(MessageFactory.Text(replyText, replyText), cancellationToken) Var empNumber = Д®mployee employee = FetchEmployeeName(empNumber) Protected override async Task OnMessageActivityAsync(ITurnContext turnContext, CancellationToken cancellationToken)

Select e).FirstOrDefault() //Query for employee details with id Public Employee FetchEmployeeName(string no)

Bot framework emulator mac