SqlConnectionStringBuilder.MultipleActiveResultSets 属性
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
如果为 true，则应用程序可以维护多个活动结果集 (MARS)。 如果为 false，则应用程序必须先处理或取消某一批中的所有结果集，才可以在该连接上执行任何其他批次。
有关详细信息，请参阅多个活动结果集 (MARS)。
public:
property bool MultipleActiveResultSets { bool get(); void set(bool value); };public bool MultipleActiveResultSets { get; set; }member this.MultipleActiveResultSets : bool with get, setPublic Property MultipleActiveResultSets As Boolean属性值
为 MultipleActiveResultSets 属性的值，或者，如果未提供任何值，则为 false。
示例
以下示例显式启用“多个活动结果集”功能。
using System.Data.SqlClient;
class Program
{
static void Main()
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "(local)";
builder.IntegratedSecurity = true;
builder.InitialCatalog = "AdventureWorks";
// The connection does not allow multiple active result sets
// by default, so this line of code explicitly
// enables this feature. Note that this feature is
// only available when programming against SQL Server 2005
// or later.
builder.MultipleActiveResultSets = true;
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
Console.WriteLine("Press Enter to continue.");
Console.ReadLine();
}
}
Imports System.Data.SqlClient
Module Module1
Sub Main()
Dim builder As New SqlConnectionStringBuilder
builder.DataSource = "(local)"
builder.IntegratedSecurity = True
builder.InitialCatalog = "AdventureWorks"
' The connection does not allow multiple active result sets
' by default, so this line of code explicitly
' enables this feature. Note that this feature is
' only available when programming against SQL Server 2005
' or later.
builder.MultipleActiveResultSets = True
Console.WriteLine(builder.ConnectionString)
Console.WriteLine()
Console.WriteLine("Press Enter to continue.")
Console.ReadLine()
End Sub
End Module
注解
此属性与连接字符串内的“MultipleActiveResultSets”键相对应。
