Querying XML like SQL?

Question

Is there any framework for querying XML SQL Syntax, I seriously tire of iterating through node lists.

---

Or is this just wishful thinking (if not idiotic) and certainly not possible since XML isn't a relational database?

Answer 1

XQuery and XPath... XQuery is more what you are looking for if a SQL structure is desirable.

Answer 2

You could try LINQ to XML, but it's not language agnostic.

Answer 3

.Net Framework provides LINQ to do this or you can use the .Net System.Data namespace to load data from XML files.

You can even create queries that have joins among the tables, etc.

For example, System.Data.DataTable provides a ReadXml() method.