Tmess
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The world (ie: Microsoft) seems to be going the XML route. Seconded.
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.
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.
Very flexible, very fast for small amounts of data.