Multiple Active Result Sets

http://msdn.microsoft.com/en-us/library/cfa084cz.aspx

这个功能首先需要数据库支持。从SQL Server 2005开始就支持了。其次在ADO.NET中需要明确地声明使用该特性。它的好处就是在一个连接没有关闭，并且正在使用的情况下，同时可以读取多个结果集。以前只能同时读取一个结果集

Multiple Active Result Sets (MARS)

This page is specific to:.NET Framework Version:

Multiple Active Result Sets (MARS) is a feature that allows the execution of multiple batches on a single connection. In previous versions, only one batch could be executed at a time against a single connection. Executing multiple batches with MARS does not imply simultaneous execution of operations.

In This Section

Enabling Multiple Active Result Sets (MARS): Discusses how to use MARS with SQL Server 2005.
Manipulating Data (MARS): Provides examples of coding MARS applications.

Related Sections

Asynchronous Operations (ADO.NET): Provides details on using the new asynchronous features in ADO.NET.