Whether to use dataset or array of objects

[Raghav]

Hi,

I've a Windows based .Net distributed application. One of the scenarios is
getting multiple records from the database at the presentation layer and
showing that in a DataGrid control. The user should be able to add / modify
/ delete records. All this updation will be passed to the business layer and
business layer will update the database. I've come to know that using the
dataset have performance issue and, instead, we can use an array of objects.
I would like to know which is the better option.

Thanks & Regards,
-Raghav.

 

[Greg]

Business Objects are great, if you have the time to code them up and DataSet
does not meet your requirements. We had this discussion early on. To
resolve it, we spent some quality time with DataSet, took him to lunch,
dinner, got to know him real well. We discovered he met all of our
requirements, so we used him.

I would think, in most, if not close to all applications, DataSet will meet
your needs.

Good book on using business objects :"VB.NET Business Objects" by Rocky
Lhotka.

 

[Eric Cadwell]

I would agree. I recall that a lot of the sample applications from MS
(Petshop, Duwamish, etc) use DataSets returned from a Business or Data layer
directly. This povides a consistent API and forces you to decouple the
client logic and business layers completely.

Eric Cadwell
http://www.origincontrols.com