Platform: Win2000, WinXP
SQLXML supports only SQLServer. SQLServer, Oracle and DB2 have native support for XML too, although I don't know what their APIs look like. Probably they would implement an ExecuteXmlReader method somehow. By native support I mean you can store XML in a single field, and have additional semantics on it, such as indexing, querying, well-formedness checks, and so on. The proposed ANSI SQL-2003 standard includes the XML datatype:http://www.wiscorp.com/sql/SQL2003Features.pdf. The way that native support is exposed through .NET APIs depends on the specific ADO.NET data provider. The SqlClient provider exposes the ExecuteXmlReader method I mentioned.
This was first published in June 2004