It is probably easy, but I am a bit lost in the mess of VB.Net classes.
With ADODB it is easy to define a recordset with different properties, but the SqlDataReader is very rigid. No RecordCount, no Sort(), no Filter.
I do see a SqlDataAdapter class, but I don't need to adapt any data. I just want something like an ADODB.RecordSet that supports the Filter property.
Sample code I found looked needlessly complicated, involving both a SqlDataAdapter (i don't need to adapt data) and a DataSet (of which I do not see something comparable to a Filter property)