How to pass comma separated values to LINQ query without for loop

Question

I have list of values separated by commas, I need to pass these values to LINQ query and get matching values from DB, I have used for loop to solve this problem

here is my code

string drawingList="a,b,c,d";
string[] drawings = drawingList.Trim(',').Split(',');
IQueryable<table> filteredItems = null;
filteredItems =(some linq query)
List<table> filteredResult = new List<table>();
for (int i = 0; i < drawings.Count(); i++)
{
    dr = drawings[i].Trim();
    filteredItems = filteredItems.Where(p1 => p1.WorkItemNumber.Equals(dr));
                    filteredResult.AddRange(filteredItems);
}

How can I solve the above problem without the for loop

Eranga · Accepted Answer · 2012-02-01 03:45:57Z

3

Try

filteredItems = filteredItems.Where(i => drawings.Contains(i => i.WorkItemNumber));

answered Feb 1, 2012 at 3:45

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sblom · Accepted Answer · 2012-02-01 03:29:34Z

1

var result = from   drUntrimmed in drawings
               let  dr = drUntrimmed.Trim()
             from   f in filteredItems
             where  f.WorkItemNumber.Equals(dr)
             select f;

answered Feb 1, 2012 at 3:29

sblom

27.5k4 gold badges74 silver badges96 bronze badges

Collectives™ on Stack Overflow

How to pass comma separated values to LINQ query without for loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related