XML LINQ VB.Net

Imports System
Imports System.Xml.Linq
    Public Class MainClass
        Public Shared Sub Main()
            Dim employees As XElement = XElement.Load("Employees.xml")
            Dim titles As XElement = XElement.Load("Titles.xml")
            Dim query = From emp In employees. _
                        Group Join title In titles. _<br/>                        On emp.@id Equals title.@empId _<br/>                        Into TitleList = Group _<br/>                        Select EmployeeName = emp.<Name>.Value, _<br/>                               TitleList<br/>            For Each emp In query<br/>                Console.WriteLine(emp.EmployeeName)<br/>                For Each title In emp.TitleList<br/>                    Console.WriteLine("{0} - {1}", title.<Name>.Value, title.<Status>.Value)<br/>                Next<br/>            Next<br/>        End Sub<br/>    End Class </code> </div> </div> <br /> <footer class="py-12 bg-dark"> <div class="container"> <div class="row mb-12"> <div class="col-md-12"> <p class="text-center text-black">Copyright © Mega Code Archive 2024</p> </div> </div> <div class="row mb-12"> <div class="col-md-2"> <div class="row"> .NET </div> <div class="row"> <a href="/Page/Categories/2/ASP Net">ASP.Net</a> </div> <div class="row"> <a href="/Page/Categories/3/ASP Net Tutorial">ASP.Net Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/6/C#">C#</a> </div> <div class="row"> <a href="/Page/Categories/7/C# Book">C# Book</a> </div> <div class="row"> <a href="/Page/Categories/8/C# by API">C# by API</a> </div> <div class="row"> <a href="/Page/Categories/9/C# Tutorial">C# Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/38/VB Net">VB.Net</a> </div> <div class="row"> <a href="/Page/Categories/39/VB Net by API">VB.Net by API</a> </div> <div class="row"> <a href="/Page/Categories/40/VB Net Tutorial">VB.Net Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/41/Visual CPlusPlus Net">Visual C++ .Net</a> </div> <div class="row"> <a href="/Page/Categories/42/VisualBasic Script">VisualBasic Script</a> </div> </div> <div class="col-md-2"> <div class="row"> Java </div> <div class="row"> <a href="/Page/Categories/15/Java">Java</a> </div> <div class="row"> <a href="/Page/Categories/16/Java Book">Java Book</a> </div> <div class="row"> <a href="/Page/Categories/17/Java by API">Java by API</a> </div> <div class="row"> <a href="/Page/Categories/18/Java Tutorial">Java Tutorial</a> </div> <div class="row"> Script </div> <div class="row"> <a href="/Page/Categories/13/Flash ActionScript">Flash ActionScript</a> </div> <div class="row"> <a href="/Page/Categories/14/Flex">Flex</a> </div> <div class="row"> <a href="/Page/Categories/19/JavaScript DHTML">JavaScript DHTML</a> </div> <div class="row"> <a href="/Page/Categories/20/JavaScript Reference">JavaScript Reference</a> </div> <div class="row"> <a href="/Page/Categories/21/JavaScript Tutorial">JavaScript Tutorial</a> </div> </div> <div class="col-md-2"> <div class="row"> Database </div> <div class="row"> <a href="/Page/Categories/25/MSSQL">MSSQL</a> </div> <div class="row"> <a href="/Page/Categories/26/MSSQL Tutorial">MSSQL Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/27/MySQL">MySQL</a> </div> <div class="row"> <a href="/Page/Categories/28/MySQL Tutorial">MySQL Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/29/Oracle PLSQL">Oracle PLSQL</a> </div> <div class="row"> <a href="/Page/Categories/30/Oracle PLSQL Tutorial">Oracle PLSQL Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/33/PostgreSQL">PostgreSQL</a> </div> </div> <div class="col-md-2"> <div class="row"> Languages </div> <div class="row"> <a href="/Page/Categories/1/Android">Android</a> </div> <div class="row"> <a href="/Page/Categories/4/C">C</a> </div> <div class="row"> <a href="/Page/Categories/5/C Tutorial">C Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/10/CPlusPlus">C++</a> </div> <div class="row"> <a href="/Page/Categories/11/CPlusPlus Tutorial">C++ Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/12/Delphi">Delphi</a> </div> <div class="row"> <a href="/Page/Categories/31/Perl">Perl</a> </div> <div class="row"> <a href="/Page/Categories/32/PHP">PHP</a> </div> <div class="row"> <a href="/Page/Categories/34/Python">Python</a> </div> <div class="row"> <a href="/Page/Categories/35/Python Tutorial">Python Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/36/Ruby">Ruby</a> </div> <div class="row"> <a href="/Page/Categories/37/Silverlight">Silverlight</a> </div> </div> <div class="col-md-2"> <div class="row"> Office </div> <div class="row"> <a href="/Page/Categories/22/MSOfficeExcel 2007 Tutorial">MSOfficeExcel 2007 Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/23/MSOfficePowerPoint 2007 Tutorial">MSOfficePowerPoint 2007 Tutorial</a> </div> <div class="row"> <a href="/Page/Categories/24/MSOfficeWord 2007 Tutorial">MSOfficeWord 2007 Tutorial</a> </div> <div class="row"> Data </div> <div class="row"> <a href="/Page/Categories/43/XML">XML</a> </div> <div class="row"> <a href="/Page/Categories/44/XML Tutorial">XML Tutorial</a> </div> </div> <div class="col-md-2"> <div class="row"> Others </div> <div class="row"> <a href="/Home/About">About</a> </div> </div> </div> </div> </footer> </div> </body> </html>