I have an array of itemIDs: 5, 7, 8, 1, 2, 4, ... (itemID is indexed field in my table tblTest)
I need to open DatarRader and read records in the given order.
What is an efficient way to do this?
My first thought was to create DataReader for each ItemID (place everything in foreach loop). That seems not efficient to me.
I was looking around for Seek method (to open DataReader and use Seek to navigate through records in above order), and I found that SqlCeDataReader object has this method, but couldn't figure out how to register it and use it in my project. I am not even sure if I am supposed to use it.
Thanks.
Start Free Trial
