| David Crone 2005-06-09, 11:23 am |
| Hi Ross
All was going fine, and looked like transfer was relatively painlessly -
BUT Have hit a bit of a snag - Have got it all running under one
Connection, but in my 3-tier Collection / Stateful class architecture I
use DataReaders instead of Datasets.
The problem arises because it seems I cannot have more than 1 Datareader
open at one time...which means that using Datareaders and a
Single-Connection structure, I can never have an Object that contains
instances of other Objects; as when I do a GetAll for example, while its
reading the data from my DataReader into my Collection, if it has to
load some other data to put into my Stateful class, it needs another
DataReader, but thats not possible because I'm still busy reading data
from the first one!!
What is the 'Correct' way to build in Application Role support if you
use Datareaders?? Not a chance can I shift over to Datasets at this
stage!!
Any ideas?
Thanks in advance
David Crone
*** Sent via Developersdex http://www.droptable.com ***
|