[C#] MultipleActiveResultSets=True or multiple connections?
This is as far as I know the reason MARS was added, so yeah I think you should use it.
I have some C# in which I create a reader on a connection (
ExecuteReader), then for every row in that reader, perform another command (with
ExecuteNonQuery). In this case is it better that I use
MultipleActiveResultSets=True on my connection or use multiple connections?