Using LINQ to Parse XML Document with Namespace in Root Element

1. issue your problem is that you do not give a name to your namespace. for example:
   <Message xmlns:name="http://www.myurl.com/Product" version="010" release="006">.

   When you do not use a custom name for your namespace you must use the whole namespace as an identifier.

   This is the name of the Body without the custom name {{http://www.myurl.com/Product}Body} and this is with the custom name {Body} (Now you will be asking why the element body does not have the preceding {name:Body} at its name this is happening because it does not have any naming implications)

2. You can use the Null Conditional Operator.
   For example: t.Element("Product").Element("Description").Element("Identification").Element("ID1")?.Value

3. Although this is not an answer LINQ basically is a way to do a complicated foreach. So the only thing that i would do its maybe use XPath instead of chaining elements that may in the feature any one of them may end up null.

I hope i helped. If any question comes up feel free to ask and i will try to explain.

Thanks,

EDIT:

When you want to find a xml node using Namespace you can use this kind of code. (If i did something wrong please spare me i'm C# Dev not Visual Basic)

Dim nameSpace As xDoc.Root.GetDefaultNamespace()?.NamespaceName
Dim body As xDoc.Descendants(XName.Get("Body", nameSpace))
Dim productXName As XName.Get("Product", nameSpace)
Dim descriptionXName As XName.Get("Description", nameSpace)
Dim identificationXName As XName.Get("Identification", nameSpace)
Dim id1XName As XName.Get("ID1", nameSpace)
Dim id2XName As XName.Get("ID2", nameSpace)
Dim typeXName As XName.Get("Type", nameSpace)
Dim nameXName As XName.Get("Name", nameSpace)
Dim query As From t In body
            select New With {Key _                        
                        .ID1 = t.Element(productXName).Element(descriptionXName).Element(identificationXName).Element(id1XName)?.Value,
                        .ID2 = t.Element(productXName).Element(descriptionXName).Element(identificationXName).Element(id2XName)?.Value,
                        .Name = t.Element(productXName).Element(descriptionXName).Element(typeXName).Element(nameXName)?.Value}

' Updated Working VB.Net Code

Public Function GetProductDetail() As String
    Dim xDoc As XDocument = Nothing
    Dim returnValue As String = ""

    Using xr As XmlReader = XmlReader.Create("C:\Automation\Example.xml")
        xDoc = XDocument.Load(xr)
        Dim xn = xDoc.Root.GetDefaultNamespace()?.NamespaceName
        Dim body = xDoc.Descendants(XName.Get("Body", xn))
        Dim productXName = XName.Get("Product", xn)
        Dim descriptionXName = XName.Get("Description", xn)
        Dim identificationXName = XName.Get("Identification", xn)
        Dim id1XName = XName.Get("ID1", xn)
        Dim id2XName = XName.Get("ID2", xn)
        Dim typeXName = XName.Get("Type", xn)
        Dim nameXName = XName.Get("Name", xn)
        ' Name1 May or Maynot exist in the XML file
        Dim nameXName1 = XName.Get("Name1", xn)

        ' DT May or May not Exist in recived XML File
        Dim query = From t In body
                    Select New With {Key _
                        .ID1 = t.Element(productXName).Element(descriptionXName).Element(identificationXName).Element(id1XName)?.Value,
                        .ID2 = t.Element(productXName).Element(descriptionXName).Element(identificationXName).Element(id2XName)?.Value,
                        .Name = t.Element(productXName).Element(descriptionXName).Element(typeXName).Element(nameXName)?.Value,
                        .DT = t.Element(productXName).Element(descriptionXName).Element(typeXName).Element(nameXName1)?.Value}


        For Each item In query
            returnValue = $"ID1: {item.ID1} | ID2: {item.ID2} | Name: {item.Name} | DT: {item.DT} "
        Next
    End Using
    Return returnValue
End Function