Thoughts on ADO.Net DataReader
I was wondering what your thoughts were on the ADO.Net DateReader.
One thing I HATE is that you cannot have a DataReader open, and yet at the same time perform other operations on the database.
For example, if you've got a data areader open and whilst open you attempt an insert on a (completely different) table, you get the following error:
Quote:
Additional information: There is already an open DataReader associated with this Connection which must be closed first.
you could do this in ADO 2.x
tsk tsk tsk :mad: