We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

thenthorn1010
on
Medium Priority
254 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
You have to use two separate connections.
Senior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.