Needed to replace int with int array

Question

I have been struggling to update below query since yesterday but no luck.

In below query I needed to replace int idSiteno with int[] SelectedidSiteno - you see replacing int with int array.

I tried with .Contains .Any almost everything but no way near the solution. Could you please help here.

ICollection<Department> dbList = _db.Departments
                                 .Include(l => l.Sites)
                                 .Where(l => l.idCompany == idCompany && l.Disabled == "N" 
                                             && l.Sites.Any(x => x.idSite == idSiteno))
                                 .OrderBy(l => l.SortOrder).ToList();

Do you want to use a query similar to the Where Id IN (select ... of SQL? — Fabulous
– Fabulous, Commented Jun 22, 2017 at 18:24
My query will be to extract all the data from department table where company id matches and all idsite's of sites collection matches for all the selected id's in SelectedidSiteno — Gagandeep Singh Randhawa
– Gagandeep Singh Randhawa, Commented Jun 22, 2017 at 18:27

Marcus Höglund · Accepted Answer · 2017-06-22 18:24:46Z

5

So the contains does not work?

ICollection<Department> dbList = _db.Departments
.Include(l => l.Sites)
.Where(l => l.idCompany == idCompany && l.Disabled == "N" && l.Sites.Any(x => SelectedidSiteno.Contains(x.idSite)))
.OrderBy(l => l.SortOrder).ToList();

answered Jun 22, 2017 at 18:24

Marcus Höglund

16.9k11 gold badges53 silver badges72 bronze badges

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

5 Comments

Marcus Höglund Over a year ago

@GagandeepSinghRandhawa please upvote/mark as answer if this answer helped you

Salah Akbari Over a year ago

@MarcusH Right answer +1. However it seems the OP is not familiar with voting and accepting, based on his profile and his other questions unfortunately.

Marcus Höglund Over a year ago

@S.Akbari you are a true hero! To bad there are so many who just take answers and don't have the mannors to accept

Gert Arnold Over a year ago

Sorry to spoil the party, but I don't think this is what OP asked for. I think they want Departments with only Sites that match a couple of ids. Yet another incarnation of the filtered Include question...

Marcus Höglund Over a year ago

@GertArnold when I read the OPs first comment on my answer I think he was satisfied..but who knows

NtFreX · Accepted Answer · 2017-06-22 21:00:24Z

0

All the data from department table where company id matches and all idsite's of sites collection matches for all the selected id's in SelectedidSiteno

You can use All to check if every entry matches an specific expression. For example if all sites of an department match the selected collection.

ICollection<Department> dbList = _db.Departments
    .Include(l => l.Sites)
    .Where(l => l.idCompany == idCompany && 
        l.Disabled == "N" && 
        SelectedidSiteno.All(x => l.Sites.Any(s => s.idSite == x)))
    .OrderBy(l => l.SortOrder).ToList();

edited Jun 22, 2017 at 21:00

answered Jun 22, 2017 at 18:31

NtFreX

11.5k3 gold badges47 silver badges67 bronze badges

Collectives™ on Stack Overflow

Needed to replace int with int array

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related