Linq to XML query on multiple elements

[CSharpUser]

Hi all, and thanks in advance for your help.

I am trying to write a Linq to XML query that will test attribute values in multiple elements and return the possibly multiple qualifying entries from a main element. The XML I'm looking at is basically like this:

<ContentList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:noNamespaceSchemaLocation="../ContentList.xsd">
  <ContentType Type="Live">
    <Content Type="Live" Id="8475" ChannelorUrl="8475" Deploy="MulticastICC" SystemType="RTP" TotalBitrate="2200" BranchName="Working_Branch">
      <Video Codec="H264" Resolution="480x480" Size="SD" Bitrate="2000" Framerate="29.97i" AspectRatio="4:3" EncodingMethod="CVBR" GOPStructure="IPBB" GOPLength="30" />
      <Pip Codec="H264" Resolution="128x96" Size="PIP" Bitrate="250" Framerate="29.97p" AspectRatio="4:3" EncodingMethod="CVBR" />
      <Audio Codec="Mpeg1L1" Channel="2.0" Bitrate="128" Samplingrate="48" Language="Eng" />
      <AnalogClosedCaption Id="CC1" CCType="608" />
    </Content>
</ContentList>

And the query I've built in C# looks like this:

XDocument contDoc = XDocument.Load("C:\\Configs\\ContentList.xml");
      XDocument profDoc = XDocument.Load("AvProfileRequest.xml");

      var searched =
        from p in profDoc.Descendants("type")
        select p.Value; //This part works
      foreach (string str in searched)
      {
        var contList =
          ((from c in contDoc.Descendants("Content")
           where (string)c.Attribute("Type") == (str)
           (from d in c.Descendants("Video")
              where (string) d.Attribute("Codec") == ("H264")
           select new
           {
             Id = (string)c.Attribute("Id")
           }
           ))).ToList();

What I am trying to do is take a value, e.g. "Live" and get the ContentType element, then query that element for values in its sub elements (Video and/or Pip and/or Audio; etc.) for specific values; then return one of more attribute values from Content. I have the code snippet above; but the build keeps failing with the error "A query body must end with a select clause or a group clause". I've tried several, what I think are logical, placements of the parenthesis; but I keep getting the same error at one location or the other.

Please advise me on what I may be doing wrong.
Thanks!

[thines01]

It looks like a parenthesis has blocked out one of the from statements so it is isolated. If it is isolated, it has to have its own select statement.
It either needs another select statement or you need to remove the extra set of parentheses to allow the from statements to work together.

[Momerath]

Try something like this

var contList = 
    (from c in contDoc.Descendants("Content")
    where (string)c.Attribute("Type") == str
    select c
    into ctemp
        where (string)ctemp.Attribute("Codec") == "H264"
        select new {
            Id = (string)c.Attribute("Id")
        }).ToList();

[CSharpUser]

Thanks Thines01! The information you provided is exactly what I needed!
Using this, I should be able to build my criteria for a varying number of "from targets"!