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:  2.03.03.54

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.