Error using XElement.Parse

Question

I have a XML configuration for Query CAML:

<add key="QueryList" value="&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='Cargar_x0020_Optimyth'/&gt;&lt;Value Type='Boolean'&gt;1&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;" />
<add key="PaginacionList" value="10" />
<add key="QueryOptions" value="&lt;IncludeMandatoryColumns&gt;FALSE&lt;/IncludeMandatoryColumns&gt;&lt;Paging ListItemCollectionPositionNext=''/&gt;" />

Now, I want do this:

    XElement ndQuery = XElement.Parse(Configuracion.QueryList);
    XElement ndViewFields = XElement.Parse(Configuracion.ViewFields);
    XElement ndQueryOptions = XElement.Parse(Configuracion.QueryOptions);

but I get an error.

I try this using XmlElement and its working:

    XmlElement ndQuery = xmlDoc.CreateElement("Query");
    if (!String.IsNullOrEmpty(Configuracion.QueryList))
    {
        ndQuery.InnerXml = Configuracion.QueryList;
    }
    XmlElement ndViewFields = xmlDoc.CreateElement("ViewFields");
    if (!String.IsNullOrEmpty(Configuracion.ViewFields))
    {
        ndViewFields.InnerXml = Configuracion.ViewFields;
    }
    XmlElement ndQueryOptions = xmlDoc.CreateElement("QueryOptions");
    if (!String.IsNullOrEmpty(Configuracion.QueryOptions))
    {
        ndQueryOptions.InnerXml = Configuracion.QueryOptions;
    }

    XElement ndQuery = XElement.Parse(ndQuery2.OuterXml);
    XElement ndViewFields = XElement.Parse(ndViewFields2.OuterXml);
    XElement ndQueryOptions = XElement.Parse(ndQueryOptions2.OuterXml);

I want avoid use XmlElement, and only XElement.

Any solution about it?

@xanatos the value if for **key="QueryList"** in app.config. — Kiquenet, Mar 13 '15 at 12:26

score 0 · Answer 1 · answered Mar 13 '15 at 12:02

Your XML in the QueryOptions setting isn't an element. It's two sibling elements. You need one surrounding them, which in this case would be <QueryOptions>:

<add key="QueryOptions" 
 value="&lt;QueryOptions&gt;&lt;IncludeMandatoryColumns&gt;FALSE&lt;/IncludeMandatoryColumns&gt;&lt;Paging ListItemCollectionPositionNext=''/&gt;&lt;/QueryOptions&gt;" />

score -1 · Answer 2 · edited May 23 '17 at 11:43

Quite complex because you have an Xml fragment (multiple root nodes) in Configuracion.QueryOptions. The XLinq doesn't have direct methods to handle it... Based on Fragmented XML string parsing with Linq, you could

public static IEnumerable<XNode> ParseXml(string xml)
{
    // Note the added escaping
    // You can replace it with WebUtility.HtmlDecode
    // They are defined in different assemblies
    xml = HttpUtility.HtmlDecode(xml);

    var settings = new XmlReaderSettings
    {
        ConformanceLevel = ConformanceLevel.Fragment,
        IgnoreWhitespace = true
    };

    using (var stringReader = new StringReader(xml))
    using (var xmlReader = XmlReader.Create(stringReader, settings))
    {
        xmlReader.MoveToContent();
        while (xmlReader.ReadState != ReadState.EndOfFile)
        {
            yield return XNode.ReadFrom(xmlReader);
        }
    }
}

and then

XElement ndQuery = new XElement("Query", ParseXml(Configuracion.QueryList));
XElement ndViewFields = new XElement("ViewFields", ParseXml(Configuracion.ViewFields));
XElement ndQueryOptions = new XElement("QueryOptions", ParseXml(Configuracion.QueryOptions));

The use of HttpUtility.HtmlDecode/WebUtility.HtmlDecode is from Built in .NET function for unescaping characters in XML stream? .

Or perhaps you want to keep the configurations encoded as they are... then

XElement ndQuery = new XElement("Query", HttpUtility.HtmlDecode(Configuracion.QueryList));
XElement ndViewFields = new XElement("ViewFields", HttpUtility.HtmlDecode(Configuracion.ViewFields));
XElement ndQueryOptions = new XElement("QueryOptions", HttpUtility.HtmlDecode(Configuracion.QueryOptions));

(much shorter :-) )

I'm pretty sure OP doesn't need to actively unescape the configuration values. — JLRishe, Mar 13 '15 at 12:04

Error using XElement.Parse

2 Answers2