DataSet & database portability

[David Thielen]

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?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

[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)
"David Thielen" <th*****@nospam.nospam> wrote in message
news:30**********************************@microsof t.com...

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?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

[David Thielen]

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.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

"Bruce Barker" wrote:

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)
"David Thielen" <th*****@nospam.nospam> wrote in message
news:30**********************************@microsof t.com...

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?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com