C# file list and find in table

See more:

C#

Looking for some help with the following.
Need to get a file list of all files in a folder.
Use part of the file name to look for an entry in a MySQL tablet.

What I have tried:

The below code will get me the file names but I am not sure how to store this in memory and then look at the table to find a match.

// Get a list of all subdirectories
         var files = from file in
         Directory.EnumerateFiles(root)
                     select file;
         Console.WriteLine("Files: {0}", files.Count<string>().ToString());
         Console.WriteLine("List of Files");
         foreach (var file in files)
         {
             Console.WriteLine("{0}", file);
         }