Update XML with C# using Linq

by

To update your xml use SetElementValue method of the XElement : 

var items = from item in xmlDoc.Descendants("item")
    where item.Element("itemID").Value == itemID
    select item;

foreach (XElement itemElement in items)
{
    itemElement.SetElementValue("name", "Lord of the Rings Figures");
}

EDIT : Yes, I tried your example and it saves updated data to the file. Save your updated xml with Save method of the XDocument, here is the code that I tried :

string xml = @"<items>
           <item>
            <itemID>1</itemID>
            <isGadget>True</isGadget>
            <name>Star Wars Figures</name>
            <text1>LukeSkywalker</text1>
           </item>
        </items>";

XDocument xmlDoc = XDocument.Parse(xml);

var items = from item in xmlDoc.Descendants("item")
            where item.Element("itemID").Value == "1"
            select item;

foreach (XElement itemElement in items)
{
    itemElement.SetElementValue("name", "Lord of the Rings Figures");
}

xmlDoc.Save("data.xml");

More Related Contents:

  1. Parse Xml response from a get method in C# using Linq
  2. LINQ to read XML
  3. Dynamically generate LINQ queries
  4. XElement namespaces (How to?)
  5. XDocument containing namespaces
  6. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  7. Query an XDocument for elements by name at any depth
  8. Edit specific Element in XDocument
  9. Serialize an object to XElement and Deserialize it in memory
  10. Query Xml File for Records using Linq
  11. Linq to XML – update/alter the nodes of an XML Document
  12. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  13. Case insensitive XML parser in c#
  14. Return anonymous type results?
  15. How to do a subquery in LINQ?
  16. Format a date in XML via XSLT
  17. Escape invalid XML characters in C#
  18. How to check if IEnumerable is null or empty?
  19. Combine two Linq lambda expressions
  20. Filter a list by another list C#
  21. Easiest way to Rotate a List in c#
  22. Find substring in a list of strings
  23. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  24. List sort based on another list
  25. Remove duplicate items from list in C#, according to one of their properties
  26. Entity Framework core – Contains is case sensitive or case insensitive?
  27. How to do an “in” query in entity framework?
  28. How can I transform XML into a List or String[]?
  29. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  30. Where can I find the System.Linq.Dynamic dll?

Leave a Comment