Select a string in a list of strings linq

Question

Here I have a list of string in sites1. I need to check the common items between sites1 and items1 and select the matching items from items1. Here is my code

 string query = "/sitecore/content/*";
 List<string> sites1 = Sitecore.Configuration.Settings.Sites.Select(x => x.StartItem.TrimStart('/')).ToList();
 List<Item> items1 = Sitecore.Context.Database.SelectItems(query).Where(x => x.DisplayName.Contains(sites1)).ToList();

Any suggestion?

Edit: Here i am getting the error while selecting two items

 var sites = Sitecore.Configuration.Settings.Sites.Select(f => new List<string>() { f.StartItem.TrimStart('/'), f.Language }).ToList();
 List<Item> items = Sitecore.Context.Database.SelectItems(query).Where(x => sites.Contains(x.DisplayName.ToLower())).ToList();

Tried it and getting the following error 'Sitecore.Data.Items.Item' does not contain a definition for 'sites1' and no extension method 'sites1' accepting a first argument of type 'Sitecore.Data.Items.Item' could be found (are you missing a using directive or an assembly reference?) — Rooney
– Rooney, Commented Jan 9, 2016 at 6:50
@Rooney: Do you use "Language" in the second query SelectItems().Where(...) ? — alexm
– alexm, Commented Jan 9, 2016 at 8:42

alexm · Accepted Answer · 2016-01-09 09:19:20Z

2

It should be the other way around: site1.Contains(x.DisplayName). Also, compared to a list HashSet<string> is more efficient for multiple look-ups, which becomes noticable as the number of items increases.

var sites1 = new HashSet<string>(Sitecore.Configuration.Settings.Sites
        .Select(x => x.StartItem.TrimStart('/')));

var items1 = Sitecore.Context.Database.SelectItems(query)
        .Where(x => site1.Contains(x.DisplayName))
        .ToList();

EDIT:

I did not notice that SelectItems() returns IQueriable. In that case I would re-write the second statement using IEnamerable.Any<> extention method, which can be projected into server SQL query.

var items1 = Sitecore.Context.Database.SelectItems(query)
        .Where(x=>sites1.Any(it=>it == x.DisplayName))
        .ToList();

EDIT 2: Correcting the query from the edited question:

var sites1 = Sitecore.Configuration.Settings.Sites
        .Select(x => new {DisplayName = x.StartItem.TrimStart('/'), Language = x.Language});

var siteNames = new HashSet<string>(sites1.Select(x=> x.DisplayName.ToLower());

var items1 = Sitecore.Context.Database.SelectItems(query)
        .Where(x=>siteNames.Any(it=>it == x.DisplayName.ToLower()))
        .ToList();

edited Jan 9, 2016 at 9:19

answered Jan 9, 2016 at 6:52

alexm

6,89022 silver badges24 bronze badges

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

2 Comments

Rooney Over a year ago

DisplayName doesnot exist

Rooney Over a year ago

Working fine now..Appreciate your help

scartag · Accepted Answer · 2016-01-09 06:53:50Z

2

List<Item> items1 = Sitecore.Context.Database.SelectItems(query).Where(x => sites1.Contains(x.DisplayName)).ToList();

answered Jan 9, 2016 at 6:53

scartag

17.7k3 gold badges52 silver badges53 bronze badges

Collectives™ on Stack Overflow

Select a string in a list of strings linq

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related