question

amalanj avatar image
0 Votes"
amalanj asked amalanj commented

Azure Bot Save conversation to azure SQL using C#

Team,

Please help me in understanding the feasibility of saving the User and Conversation data to Azure SQL. From the documentation I read, the IStorage has an implementation for MemoryStorage, BlobStorage and CosmosDBStorage. In extension to this, can we also have the conversations to be stored directly to Azure SQL using C#? Kindly assist.

Thanks,
Amalan Jagan



azure-bot-service
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

romungi-MSFT avatar image
1 Vote"
romungi-MSFT answered amalanj commented

@Amalanj I think a similar query to store user and conversation data in Azure SQL is addressed in this github issue from botbuilder samples repo. Please check the same for details on the implementation from Eric's repo here. I hope this helps.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @romungi-MSFT. It really helps me to progress.
Based on the EntityFrameworkTranscriptStoreExample, I was able to record the transcripts in Azure SQL Table [dbo].[TranscriptEntity], but I miss the entries on the Table [dbo].[BotDataEntity]. Is there a piece of code that I miss?




0 Votes 0 ·