Link to home
Start Free TrialLog in
Avatar of thenthorn1010
thenthorn1010Flag for United States of America

asked on

How Do You Use Two Data Readers At Same Time Within VB .NET 2010

I was wondering if it was possible to run two data readers that would access the same database at the same time. (The purpose is to save memory depending of if certain logic is required in order to call tthe second data reader. The purpose is to limit how much data is loaded into RAM memory on a server.) These two data readers would be attached to the same database and would be accessing two different tables that are within the same database. Would this be possible, number one? Is there a better way to use data readers to pull from another table to make a more complex query after the data has been called from the inital data reader to limit the amount of memory being used due to the results set that would be returned from the query that is passed to each of the data readers, with the second one being dependent on whether or not a block of code would be called or not.
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

You have to use two separate connections.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial