Linq to XML file query not working

Question

This is my XML file and I am using linq and entity framework

<?xml version="1.0" encoding="utf-8" ?>
<Projects>
  <Project ProjectId="JP001" Country="Canada" ProposedBy="Jim Priac"/>
  <Project ProjectId="KS12" Country="Canada" ProposedBy="Aya Suriour"/>
  <Project ProjectId="ANS16" Country="Malesia" ProposedBy="Gour martin"/>
 <Projects>

the linq query I am using is

   IEnumerable<string> Proposed_By = from project in xmldoc.Descendants("Projects").Elements("Project")
                                            where project.Attribute("Country") == "Canada"
                                             select project.Attribute("ProposedBy");

but I am not getting correct output

How do you load the xmldoc? And is it of XDocument or XmlDocument? Could be helpful if you showed the loading code as well. — fuchs777
– fuchs777, Commented Sep 10, 2014 at 6:45

Andrei V · Accepted Answer · 2014-09-10 06:47:22Z

1

You need to compare to the value of the attribute and not to the attribute itself.

IEnumerable<string> Proposed_By = 
        from project in xmldoc.Descendants("Projects").Elements("Project")
        where project.Attribute("Country").Value == "Canada"
        select project.Attribute("ProposedBy").Value;

I would however go a step further and also check if the attribute is there (since calling the Value property on a null object would result in an exception:

IEnumerable<string> Proposed_By = 
        from project in xmldoc.Descendants("Projects").Elements("Project")
        where project.Attribute("Country") != null 
              & project.Attribute("Country").Value == "Canada"
              & project.Attribute("ProposedBy") != null
        select project.Attribute("ProposedBy").Value;

edited Sep 10, 2014 at 6:47

answered Sep 10, 2014 at 6:38

Andrei V

7,5187 gold badges48 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hine32 Over a year ago

Thanks but i am not getting output

V2Solutions - MS Team · Accepted Answer · 2014-09-10 06:39:39Z

0

First see if your file is getting make corrections to your linq query

XDocument xmldoc = XDocument.Load(Path.GetFullPath("filename"));
    IEnumerable<string> Proposed_By = from project in xmldoc.Descendants("Projects").Elements("Project")
                                    where project.Attribute("Country").Value == "Canada"
                                     select project.Attribute("ProposedBy").Value;

answered Sep 10, 2014 at 6:39

V2Solutions - MS Team

1,1276 silver badges6 bronze badges

1 Comment

hine32 Over a year ago

Ya @V2Solutions- MS Team

Arnaud Rinquin · Accepted Answer · 2014-09-10 07:57:52Z

0

Use .Value with attribute names

edited Sep 10, 2014 at 7:57

Arnaud Rinquin

4,2961 gold badge32 silver badges51 bronze badges

answered Sep 10, 2014 at 6:46

James

1701 gold badge2 silver badges10 bronze badges

Comments

Thirisangu Ramanathan · Accepted Answer · 2014-09-10 09:37:41Z

0

Another Way: It returns NULL if Value is not present.

 var Propposed_By = from project in xd.Descendants("Projects").Elements("Project")
                           where project.Attribute("Country").Value == "Canada"
                           select (string)project.Attribute("ProposedBy");

answered Sep 10, 2014 at 9:37

Thirisangu Ramanathan

6141 gold badge12 silver badges20 bronze badges

Collectives™ on Stack Overflow

Linq to XML file query not working

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related