C# using linq statement

Question

For code that is wruitten as C# 2008 desktop/windows form application, I have the following code that exists:
string[] excelFiles = Directory.GetFiles(strStartPath, "*ErrorReport*.xlsx")
        .Select(path => Path.GetFileName(path))
        .Where(x => !x.StartsWith("~")) //prevents files in alternate location from being selected
        .ToArray();

I want to be able to look for files that say either "*ErrorReport*.xlsx" or ""*CustomerReport*.xlsx". However i
can not get this code to take any kind of a 'or' statement I give to.

Thus can you show me how to change the code so that it will look for either ErrorReport or CustomerReport?

Vulpes · Answer

If you mean the 'combined' solution then the code would be on these lines: var excelFiles1 = Directory.GetFiles(strStartPath *ErrorReport*.xlsx) .Select(path => Path.GetFileName(path)) .Where(x => !x.StartsWith(~)); var excelFiles2 = Directory.GetFiles(strStartPath *CustomerReport*.xlsx) .Select(path => Path.GetFileName(path)) .Where(x => !x.StartsWith(~)); string[] excelFiles = excelFiles1.Union(excelFiles2).ToArray();

dc · Answer

I want to mention the following additional comments: 1. The code you should be works fine. 2. i have another post called 'change C# code into a dll'. Is there any way that you would know the answer to this question and/or be able to point me to a source could answer the question for me?

dc · Answer

can you show me a code example of what you are referring to?

Vulpes · Answer

The Directory.GetFiles method doesn't have any facility for OR'ing different filters together. You'll either need to run a similar query for each filter and then process the results separately or you could use the Union extension method to combine the arrays and then process the combined set: http://msdn.microsoft.com/en-us/library/bb341731.aspx