Handling of xml data within Oracle 9/10 and sql Server 2005

[Oriane]

Hi there,

I would like to know the best way to handle Xml data stored on Oracle and
Sql Server 2005 using XQuery/XPath and AdoNet. Ideally, the C# code should
not be different for Oracle and Sql Server. Any hint ?

Regards

[sloan]

Sql Server 2005/2000 has a OPENXML statement.

When I used Oracle 9 (while back), I was very disappointed in its xml
capabilities.
First question:

Are you pushing xml into the db, or reading it out?
It looks like reading it out, but wanted to make sure.

"Oriane" <or****@guermantes.frwrote in message
news:BD**********************************@microsof t.com...

Hi there,

I would like to know the best way to handle Xml data stored on Oracle and
Sql Server 2005 using XQuery/XPath and AdoNet. Ideally, the C# code should
not be different for Oracle and Sql Server. Any hint ?

Regards