Loop through IEnumerable Using Array MVC

Question

Been struggling with this and don't know how to implement. Seems easy of enough.

I have a search box that takes multiple keywords. I then take those keywords and pass them to my IENumerable method in my repository.

public IEnumerable<diss> GetDissSearch(string b)

Then I place keywords into array - b contains the string of words and use Split method.

string[] sArray = strSearchString.Split();

Then I use foreach loop to go words in my array, but within my foreach loop I place my linq statement as the following:

foreach(string s in sArray){

var myLoop = (from p in mytable
              where p.userFirstName.Contains(s)
              && p.lastName.Contains(s)
              select new myModel {
              firstName = p.userFirstName,
              lastName = p.userLastName
              }).ToList();

return myLoop;

}

So if user enters two words - for example, a first and last name, you expect that the collection would be called twice. Similarly if user entered a middle name then collection would be called three times. At the moment, this collection is only run once.

Is there way to call this ienumerable multiple times based on the number of keywords contained in my array?

Thanks.

Shimmy Weitzhandler · Accepted Answer · 2015-08-22 20:08:47Z

2

Wrap the searching query with the Any (or All if you want all the sArray terms to exist) ex. method, in this way each DB row will be evaluated against the array just once:

var myLoop = (from p in mytable
              where sArray.Any(sa => p.userFirstName.Contains(sa)
              && p.lastName.Contains(sa))
              select new myModel
              {
                firstName = p.userFirstName,
                lastName = p.userLastName
              }).ToList();

Also, consider replacing the && operator in your query with || if you want the terms to be in either first name or last name.

edited Aug 22, 2015 at 20:08

answered Aug 22, 2015 at 19:45

Shimmy Weitzhandler

105k126 gold badges437 silver badges644 bronze badges

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

1 Comment

Eds Over a year ago

This is great! Thanks so much, and yes, the && was a typo.

Collectives™ on Stack Overflow

Loop through IEnumerable Using Array MVC

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related