LINQ: How i can user where condition multi value by array string?

Question

I want to use the linq where condition multi value by array string is split(',') I list data from data file in folder. (not in database)

Code c#

public List<sFile> GettingFiles(string path)
{
    //Read File in folder
    List<sFile> allfile = new List<sFile>(); 
    DirectoryInfo di = new DirectoryInfo(path);
    FileInfo[] fileinfo = di.GetFiles("*.*");

    foreach (FileInfo item in fileinfo)
    {
        allfile.Add(new sFile
        {
            FileName = item.Name,
            Seq = int.Parse(item.Name.Substring(12, item.Name.Length - 12)),
            PmnCode = item.Name.Substring(7, item.Name.Length - 12),
            Path = item.DirectoryName,
            Size = formatSize(item.Length),
            SizeInt = int.Parse(item.Length.ToString())
        });
    }
    return allfile;
}

public void btnQuery_Click(object sender, EventArgs e)
{
    List<sFile> allFiles = GettingFiles(path); //List file in Folder
    string pmnCode = txtPMNCode.Text.ToString(); //AAAA, BBBBB, CCCCC, DDDDD
    string[] subPmnCode = pmnCode.Split(',');
    string totalPmnCode = string.Empty;

    foreach (string item2 in subPmnCode)
    {
        var queryData = from d in allFiles.AsQueryable()
                    where (d.PmnCode.Contains(item2))
                    select d;                       

        //Add Column
        DataTable dt = new DataTable();
        dt.Columns.Add(enmField.NAME.ToString());
        dt.Columns.Add(enmField.SIZE.ToString());
        dt.Columns.Add(enmField.MODIFY_DATE.ToString());
        dt.Columns.Add(enmField.PATH.ToString());

        DataRow myRow = dt.NewRow();

        foreach (sFile item in queryData.ToList())
        {
             myRow = dt.NewRow();
             myRow[enmField.NAME.ToString()] = item.FileName.Trim();
             myRow[enmField.SIZE.ToString()] = item.Size.Trim();
             myRow[enmField.MODIFY_DATE.ToString()] = item.Date;
             myRow[enmField.PATH.ToString()] = item.Path.Trim() + "\\" + item.FileName.Trim();
     dt.Rows.Add(myRow);
        }

        gvDetail.DataSource = dt;
        gvDetail.DataBind();
    }
}

Example Data

Pmn Code
AAAAA
BBBBB
CCCCC
DDDDD

I want query wheer condition by pmn_code is AAAAA,BBBBB, DDDDD I want show data

var queryData = from d in allFiles.AsQueryable()
                where (d.PmnCode.Contains("AAAAA") &&
                d.PmnCode.Contains("BBBBB") &&
                d.PmnCode.Contains("DDDDD")
)
                select d;  

But i can not query array string by result this. How can i use array linq?

please help me. Thanks advance ;)

Answer 1

Maybe you can try:

var queryData = from p in allFiles.AsQueryable()
                where subPmnCode.Any(val => p.PmnCode.Contains(val))
                select p;