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.
Dig Deeper on SQL Server and .NET development
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ...continue reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers.continue reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.