MultipleActiveResultSets=True or multiple connections?

by

Multiple Active Result Sets (MARS) was added specifically for this type of operation so that you don’t have to have two connections open at the same time to be able to read from a SqlDataReader AND execute additional batches.

MARS is compatible with SQL Server 2005 and above. To quote from MSDN docs:

Before the introduction of Multiple
Active Result Sets (MARS), developers
had to use either multiple connections
or server-side cursors to solve
certain scenarios.

For more info see:

MSDN Library – MARS Overview

Worked example reading and updating data:

MSDN Library – Manipulating Data (MARS) scroll down to ‘Reading and Updating Data with MARS’

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  3. SqlConnection SqlCommand SqlDataReader IDisposable
  4. How to keep single SQL Server connection instance open for multiple request in C#?
  5. Received an invalid column length from the bcp client for colid 6
  6. How do I connect to a SQL database from C#?
  7. Call a stored procedure with parameter in c#
  8. Insert 2 million rows into SQL Server quickly
  9. Calling stored procedure with return value
  10. Get output parameter value in ADO.NET
  11. C# Equivalent of SQL Server DataTypes
  12. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  13. SQL command INSERT is working but the data not appear in table
  14. Return value from SQL Server Insert command using c#
  15. How to pass sqlparameter to IN()? [duplicate]
  16. Populate data table from data reader
  17. Difference with Parameters.Add and Parameters.AddWithValue
  18. Code to validate SQL Scripts
  19. Connection timeout for SQL server
  20. WHERE IN (array of IDs)
  21. How DataReader works?
  22. SqlConnection.Close() inside using statement
  23. How do I re-write a SQL query as a parameterized query?
  24. Horrible performance using SqlCommand Async methods with large data
  25. Is it better to execute many sql commands with one connection, or reconnect every time?
  26. Upload CSV file to SQL server
  27. Fastest method for SQL Server inserts, updates, selects
  28. Reading a date using DataReader
  29. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  30. Should the order of LINQ query clauses affect Entity Framework performance?

Leave a Comment