0 out of 1 rated this helpful Rate this topic

Multiple Active Result Sets (MARS)

.NET Framework 4

.NET Framework 4.5
Visual Studio 2008
Visual Studio 2005

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.

Other Resources

SQL Server and ADO.NET

ADO.NET Managed Providers and DataSet Developer Center

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(2000 characters remaining)