Link to home
Start Free TrialLog in
Avatar of Tmess
TmessFlag for United States of America

asked on

Returning Data

I am creating a data access class and I was wondering what is the best way to return data to my business objects?

1. Recordset
2. Recordset to Variant array
3. Recordset to xml
4. Recordset to collection
5. Recordset to dictionary object
6. Some other way

I know best can mean a lot of things to a lot of people and I know all projects are different but nonetheless, I am interested to hear what everyone has to say.

Thanx


ASKER CERTIFIED SOLUTION
Avatar of Hornet241
Hornet241
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The world (ie: Microsoft) seems to be going the XML route. Seconded.
Avatar of ianouii
ianouii

it depends on what type of data u're carrying. u can choose the method according to your requirements. here are some views from me. Hope it helps.

1) large data, XML isn't appropriate coz it's flat file accessing.

2) Hierarchical data, XML serves the best. ease of extending sub trees.

3) cross link or complicated data. collection or dictionary should serve the purpose.

good luck.
Yep - I agree with the XML thing. You're only passing around a String data type, which is v. fast to marshal across processes.
Very flexible, very fast for small amounts of data.