| title | Multiple Active Result Sets (MARS) |
|---|---|
| description | Describes how to have more than one SqlDataReader open on a connection when each instance of SqlDataReader is started from a separate command. |
| ms.date | 08/15/2019 |
| ms.assetid | c90ef863-bac7-44cf-adc1-f05c36fcf57d |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.technology | connectivity |
| ms.topic | conceptual |
| author | David-Engel |
| ms.author | v-daenge |
| ms.reviewer | v-kaywon |
[!INCLUDEDriver_ADONET_Download]
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.
Enabling Multiple Active Result Sets
Discusses how to use MARS with SQL Server.
Manipulating data
Provides examples of coding MARS applications.
Asynchronous operations
Provides details on using the new asynchronous features in .NET.