Query XML document with where clause : Query : XML LINQ C# Source Code

Query XML document with where clause

    
 
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Linq;
using System.Reflection;
using System.Xml.Linq;

class Program {
    static void Main(string[] args) {
        XElement xml = XElement.Load(@"Employee.xml");
        var query = from p in xml.Elements("person")
                    where (int)p.Element("id") == 1
                    select p;

        foreach (var record in query) {
            Console.WriteLine("Employee: {0} {1}",
                                                record.Element("firstname"),
                                                record.Element("lastname"));
        }
    }
}

 
    
   
  
   

Related in same category :
• A Simple XML Query Using LINQ to XML
• Query XML document by attribute
• Query XML with Descendants
• Query XML document with Ancestors and First
• Get Node by type with OfType
• Query XML with namespace
• Use Linq query to get XML document elements
• Query string array by its element length
• use Linq to query an XML document