DataSet & database portability

[Guest]

Hi;

Please correct me if I am wrong. It appears that if I use a DataSet object,
that is bound to a specific database vendor - in other words I can't use it
for data that might reside on Sql Server or might be on Oracle. (Same
database schema, table & column names etc, but a different vendor.)

If I can't use DataSet, is the best approach the old create an item object
that holds all columns in 1 row and create a data access class that will do
CRUD of a row using the item object?

 

[Bruce Barker]

you are wrong.

a DataSet has no vender knowledge in it. the DataAdapter is vender specific
and moves data to/from the DataSet to the vender database.

-- bruce ((sqlwork.com)

 

[Guest]

I went and looked carefully at MyDataSet.xsd and you're right, there does not
appear to be anything provider specific in it - assuming the datatypes map
correctly.

This is really impressive that it has portability at this level of detail.