From the course: Intermediate Bot Framework for Developers

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

SQL logging

SQL logging - Azure Tutorial

From the course: Intermediate Bot Framework for Developers

Start my 1-month free trial

SQL logging

- [Instructor] Okay, now that we know how to start writing chat conversations to a flat file, we can extend this functionality to writing chat conversations to a SQL database or even an Azure data link. In this example, we look at how we can write chat conversations to a SQL database. A very fundamental question you may have is do I really need to preserve chat history? And, we talked about a few examples and how useful it is for advanced analytics and what not. But, you know, the more fundamental question is do you want to allow the user to view the transcript of the conversations with the bot. And, many bots allow this. So, you have Messenger, WhatsApp, and so on and so forth, where you can preserve the chat history for viewing purposes. So, if you do choose to preserve the conversation, Microsoft Bot Framework takes the hassle of building the rest endpoints and syncing the client in the backend. So, we can get started by first renaming our debug activity logger to SQL activity…

Contents