Hi all.
As some of you are probably beginning to get into N-Tier development with .Net I was wondering how you've been implemeting your DAL's and object persistence.
I'm trying to follow MS's primary recommended practice of typed datasets through Data-Adapters, but occasioanlly find it counter productive in some areas.
For example, if I only wish to add a new record, I need to first fill the dataset before adding the new row and performing the update method, unless I somehow alter the initial SelectCommand to return 0 records. Why would I want to return any records when I'm only adding one?
Using the datareader is obviously the most efficient method of read-only data retrieval, however if designing for scalability then datareaders should not be used between layers if the layers could possibly be located on different machines.
Implementing appropriate caching obviously negates the performance gap however the issues stil exist...
So was wondering what everyone else has been using?
DataAdapters or DataReaders?
DataSets or Custom Classes?
Single layer or Multiple (UI/Business/DAL) layer applications?
Cheers,
Andrew
Topic Options
Post Options
Thanks(0)
