[c#] MultipleActiveResultSets=True or multiple connections?



Answers

This is as far as I know the reason MARS was added, so yeah I think you should use it.

Question

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?






Related