C# + LINQ Help

[vass0922]

ok i know I can do this with a List.Sort or with a crappy bubble sort loop.. but thats not nearly enough fun

So I'm trying to use LINQ which is supposed to be great for this stuff

So ultimate goal is to connect to a directory of a lot of files and get the oldest .log file w/o doing any loops.

So far I have

namespace PollExchangeProperties
{
    class Program
    {
        static void Main(string[] args)
        {

            DirectoryInfo di = new DirectoryInfo(@"C:\code\");
            foreach (DirectoryInfo d in di.GetDirectories())
            {
                Console.WriteLine("Directory: {0}", d.Name);
                Console.WriteLine("# Files: {0}", d.GetFiles("*").Length );
                foreach (FileInfo f in d.GetFiles())
                {
                    Console.WriteLine("FileName: {0}\\{1} = {2} kb", d.Name, f.Name, f.Length/1024);
                }
            }
       }
  }
}

This obviously uses a loop, but this is just for testing

So basically I want to do this

GetDirectory
Get all *.log files in directory and return date of oldest file in that directory

Yes I know it can be done with bat easily, but again thats not a challenge
This is a great excercise for me to learn C#

[vass0922]

if this were written in Ruby, this is exactly what I want it to do

def oldest_file(dir) 
  Dir.entries(dir).map { |e| 
    File.join(dir, e) 
  }.select { |f| 
    File.file? f 
  }.sort_by { |f| 
    File.mtime f 
  }.first 
end

[vass0922]

Found some code that works well

File System search via LINQ to Objects - Jaycent Drysdale

[merlin981]

LINQ Exchange has a good article on sorting and filtering a list of files by date.
How to Use LINQ to Filter a List of Files by Date

[vass0922]

Excellent, thanks!

I'll make a note of the site as well.

[tremendo]

They have some other code over at linqhelp.com too!

[conanlive]

I know how to orderby as shown below:

var query = from c in table.AsEnumerable()
orderby c.Field<string>("Subject"),
c.Field<string>("OwnerName") ascending
select c;

DataView dv = query.AsDataView();


But How to use LINQ in C# to do group by first and then orderby ? Finally, view result....

Thanks!!!