Multiple Active Result Sets (MARS)

Download ADO.NET

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
Discusses how to use MARS with SQL Server.

Manipulating data
Provides examples of coding MARS applications.

Related sections

Asynchronous operations
Provides details on using the new asynchronous features in .NET.

Next steps

• SQL Server and ADO.NET