Query an XML file containing nested elements using LINQPad?

Question

I'm using LINQPad to query and visualize XML files with C#. For example:

var xml = XElement.Load(@"C:\file.xml");
xml.Elements().Where(e => e.Element("trHeader").Element("trTickNum").Value == "1").Dump();

However, I'd like run a query using SQL rather than C#.

Is there a way to load an XML which contains nested elements and query its table(s) using LINQPad's SQL option?

score 8 · Answer 1 · answered Oct 30 '15 at 09:55

8

This works for me.

var xml = XElement.Load(@"C:\AllTypesList.xml");
var list = xml.Elements().ToList();
var types = list.Where(x => x.Name == "XmlParamType").ToList();
types.Count().Dump();
types.GroupBy(t => t.Element("TypeName").Value).Count().Dump();

answered Oct 30 '15 at 09:55

thomas nn

933
3
13
21

To clarify: You will need to set the language dropdown to "C# Statement(s)" for this to work. – callisto Sep 13 '19 at 10:05

score 6 · Accepted Answer · answered Aug 12 '11 at 23:47

That's not possible. The SQL option requires a database to be specified and is used to query that database. It's not possible to use SQL against an XML file which has its own hierarchy. What you could do is figure out a way to load the XML into SQL, or use the XML data type in SQL, then operate on the data entirely using SQL statements.

Query an XML file containing nested elements using LINQPad?

2 Answers2