I create a column in my database call the store string path of file locations.

This column is FileUrl. 

I know I can do this in LINQ to get a list of files

from f in Directory.GetFiles((@"c:\temp"))

select f;

to get the list 

did this 

from p in Patients

from f in Directory.GetFiles((p.FilesUrl))

select f

I get this error "Method 'System.String[] GetFiles(System.String)' has no supported translation to SQL."

How can replace the ((@"c:\temp")) with ((FileUrl))