How do I connect an azure custom Q&A bot to Azure SQL DB ?

JoeS-3935 21 Reputation points
2022-10-06T07:55:04.603+00:00

Hi, I am having trouble connecting my azure bot to a SQL DB. I made a custom Q&A bot and I want to save the conversations on a azure SQL DB. I tried using Entity framework from the bot builder community, but it did not work, and I was hoping someone knew more about it?

Azure AI Bot Service
Azure AI Bot Service
An Azure service that provides an integrated environment for bot development.
751 questions
Azure AI Language
Azure AI Language
An Azure service that provides natural language capabilities including sentiment analysis, entity extraction, and automated question answering.
359 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
2,415 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoeS-3935 21 Reputation points
    2022-10-07T18:46:19.44+00:00

    Hi YutongTie, thank you for replying. It is not giving me an error, but it is not connecting to the DB. I am using the entity framework package. I am able to connect a simple Echo bot to the Azure SQL DB using entity framework but it will not work with a more complicated bot like my Custom Q&A bot. I tried to look for docs on the subject but could not find anything that helps me. Do you know any way to connect a Q&A bot to an Azure SQL DB ?

    0 comments
  2. JoeS-3935 21 Reputation points
    2022-10-07T18:46:20.107+00:00

    Hi YutongTie, thank you for replying. It is not giving me an error, but it is not connecting to the DB. I am using the entity framework package. I am able to connect a simple Echo bot to the Azure SQL DB using entity framework but it will not work with a more complicated bot like my Custom Q&A bot. I tried to look for docs on the subject but could not find anything that helps me. Do you know any way to connect a Q&A bot to an Azure SQL DB ?

    0 comments