Azure SQL数据库连接字符串 [英] Azure sql database connecionstring

问题描述

您好，如何启用 MultipleActiveResultSets设置为"TRUE"

推荐答案

，您将能够通过更新用于连接到的连接字符串来做到这一点.在蔚蓝的sql服务器数据库中，此字符串应该已经在您的Web应用的配置文件之一中列出.

you will be able to do it by updating the connection string used to connect to  azure sql server database, this string should have been listed in one of the configuration files of your web app.

例如:

Server = tcp:{azure_sql_server} .database.windows.net，1433;初始目录= {azure_sql_database}; Persist Security Info = False;用户ID = {your_username}; Password = {your_password};

Server=tcp:{azure_sql_server}.database.windows.net,1433;Initial Catalog={azure_sql_database};Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

请注意配置参数"

，您可以将连接字符串更新为设置

you may update the connection string to set MultipleActiveResultSets=True

Server = tcp:{azure_sql_server} .database.windows.net，1433;初始目录= {azure_sql_database}; Persist Security Info = False;用户ID = {your_username}; Password = {your_password};

Server=tcp:{azure_sql_server}.database.windows.net,1433;Initial Catalog={azure_sql_database};Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

这篇关于Azure SQL数据库连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！