Loading

check if linq conditions has results

check if linq conditions has results

Vignesh Kumar

10y934Visual Basic .NET

I am making some validations in an xml and remove certain elements based on date fields the below LINQ will do the job just fine.

XDocument newXML = XDocument.Load(new StringReader(xmlValue));

var q = from node in newXML.Descendants("Date") let attr = node.Value

where attr != null && DateTime.ParseExact (attr, "dd-MM-yyyy", CultureInfo.InvariantCulture)

< DateTime.Today select node.Parent;

q.ToList().ForEach(x => x.Remove());

How can I check whether this linq has identified and removed the items? OR
How can I load the results of newXML as an xml document?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Try like below:
string tempXml = @"
'tcp1' projectName='project1' />
'tcp2' projectName='project2' />
'tcp3' projectName='project3' />
";

XDocument xdoc = XDocument.Parse(tempXml);

var elementsToRemove = from elemet in xdoc.Elements("Projects").Elements("Project")
                       where elemet.Attribute("projectName").Value == "project1"
                       select elemet;

foreach (var e in elementsToRemove)
{
    e.Remove();
}

if(elementsToRemove.Count() >= 1)
{
    Console.WriteLine("Result Exist");
}
else
{
   Console.WriteLine("Result not Exist");
}
Guest User10y ago
Before removing your nodes, you can easily check:
if (q.Any())
{
    // remove your nodes
}
else
{
    // no nodes found matching your criteria
}