make a join in LINQ

[kkrylov]

Hi,
I am trying to work with XML that looks like this;
[code=xml]
<?xml version="1.0" encoding="UTF-8" ?>
<Batch>
<Page>
<Field>
<Name>Manifes t</Name>
<Value>20052000 0</Value>
</Field>
<Field>
<Name>File Name</Name>
<Value>C:\Scann ingDemo\Manifes t\PDFOutput\200 520.pdf</Value>
</Field>
</Page>
<Page>
<Field>
<Name>Manifes t</Name>
<Value>200519 </Value>
</Field>
<Field>
<Name>File Name</Name>
<Value>C:\Scann ingDemo\Manifes t\PDFOutput\200 519.pdf</Value>
</Field>
</Page>
<Page>
[/code]
I am trying to get Value()0 and value(1). I am using the following linq to do that
[code=vbnet]
Dim manifest = From m In file...<Field> _
Where m...<Name>.Valu e.ToLower = "manifest" _
Select m...<Name>.Valu e, m...<Value>.Val ue

Dim address = From f In file...<Field> _
Where f...<Name>.Valu e.ToLower = "file name" _
Select f...<Name>.Valu e, f...<Value>.Val ue
[/code]
It works great, but is there a way to create an object that would have 3 properties, i.e. Name = Manifest, Value=manifest# , address=filenam e

Thanks for your help