Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
498 Points
259 Posts
Apr 05, 2012 03:07 PM|LINK
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))
postonoh
Member
498 Points
259 Posts
Get file from file folder with LINQ
Apr 05, 2012 03:07 PM|LINK
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))