Multiple Active Result Sets and DAAB

Topics: Data Access Application Block
Jul 16, 2010 at 6:49 PM

Is MARS supported in the DAAB 4.1?  I am maxing out the number of connections available due to nested data readers.  Using MARS will keep this from happening, othewise I need to abandon the DAAB and role my own.  Has anyone else had this issue before and if you did what did you do to resolve it?



Jul 17, 2010 at 5:40 AM

DAAB supports anything ADO.NET supports so the answer is yes.  Keep in mind that MARS is supported starting in SQL Server 2005

Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.