LINQ with Two Data Sets

  • Thread starter Thread starter MitchW
  • Start date Start date
M

MitchW

Hello,

1. I have an XML file that lists filenames (i.e., a.txt, b.txt, c.txt,
etc.). I have loaded this into a LINQ var anonymous type.

2. I also have a DirectoryInfo set in another var type. This contains a
listing of all files in a certain directory.

What I ultimately need is a list of all the filenames from "1" above and if
there is a match in item "2" I need the LastWriteTime of the file. I then
need to display this in a GridView or something.

What is the best most efficient approach?

thanks,
mitch
 
MitchW said:
Hello,

1. I have an XML file that lists filenames (i.e., a.txt, b.txt, c.txt,
etc.). I have loaded this into a LINQ var anonymous type.

2. I also have a DirectoryInfo set in another var type. This contains a
listing of all files in a certain directory.

What I ultimately need is a list of all the filenames from "1" above and
if
there is a match in item "2" I need the LastWriteTime of the file. I then
need to display this in a GridView or something.

What is the best most efficient approach?

thanks,
mitch
Click to expand...

Well, a little more info may be required to help ya ... but as a start, here
is an example:

string[] fileNames = new string[] {
"a.txt", "b.txt", "c.txt"
};
DirectoryInfo di = new DirectoryInfo(@"C:\dev\test");
FileInfo[] files = di.GetFiles(@"*.txt");

var results =
from file in files where
fileNames.Contains(file.Name)
select new { file.LastWriteTime, file.Name };

foreach (var file in results) {
Console.WriteLine(
file.Name + "; " + file.LastWriteTime.ToString()
);
}

This doesn't take into account whether you have parsed the XML file or
not...

HTH,
Mythran
 
Back
Top