DataSet is a better option, especially if you are going to migrate to
ASP.NET 2.0 when Visual Studio .NET 2004 comes out.
Here is an architecture webcast that can help:
http://www.microsoft.com/usa/webcasts/ondemand/2391.asp
While I am not sure the architecture fits every app, it is easy to send
junior developers to ... to understand how you architected the solution. His
business objects layers derive from DataSet and add some features that are
highly maintainable without losing a lot of performance. Paul Sherriff
provides the code samples on his site:
www.pdsa.com.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************** ********************
Think Outside the Box!
************************************************** ********************
"C Downey" <co**************@homtail.com> wrote in message
news:OC**************@TK2MSFTNGP10.phx.gbl...
I am creating a data access layer and I'm interested in the best method of
returning data to my business tier.
My database is SQL Server 2000, and I use stored proc's.
Is it better for me to use a dataReader to get the data from the SQL
server, then load it into an arrayList and return the arrayList to my business
layer or should I use the dataset and just return that object from DAL to my
business layer.
The reason I would either use an arrayList or a dataset is that they are
easily bound to controls. Are there other, better methods?
Any advice would be greatly appreciated.
Thanks