Store XML in database - newbie question

[JezB]

I'm not sure which group to post this in, so forgive me if I post to a few,
hoping that someone can point me in the right direction.

In a .NET project (probably ASP.NET but could also be rich client), I want
to save some XML data to a database (sql-server but could also be Oracle).
How can I do this ? I certainly cant see XmlDocument as a type available for
columns in a database table, but perhaps it could be converted to/from a
Binary or Text column ?

 

[Guest]

If you are using Oracle you can define a column as an XMLType this will allow
you store and retrieve the XML as a column. In order to utilise this it is
necessary to download an addition ODP toolkit from Oracle to access it in
..Net. There is also the possibilty of storing the XML as part of the
relational database within Oracle although I haven't used that option yet.