How to get records with a where condition is a string array

Question

In the code below, profile is a string. I would like to know how to write a query in case where profile is a string array or list. ie the array or list can have multiple elements like { 'Profile1','profile2'}

var ccData = (from p in db.ChannelContacts where p.ProfileId == profile select p);

Tim Schmelter · Accepted Answer · 2015-01-07 08:59:21Z

2

You could use an efficient join:

var ccData = from p in db.ChannelContacts 
             join profileID in profiles // your collection
             on p.ProfileId equals profileID
             select p;

another less efficient option is Contains:

var ccData = from p in db.ChannelContacts 
             where profiles.Contains(p.ProfileId)
             select p;

answered Jan 7, 2015 at 8:59

Tim Schmelter

462k79 gold badges721 silver badges981 bronze badges

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

Comments

Ondrej Janacek · Accepted Answer · 2015-01-07 08:59:37Z

1

Simply ask, if profile contains that ProfileId

var ccData = (from p in db.ChannelContacts 
              where profile.Any(prof => prof == p.ProfileId) 
              select p);

answered Jan 7, 2015 at 8:59

Ondrej Janacek

12.6k14 gold badges62 silver badges96 bronze badges

Collectives™ on Stack Overflow

How to get records with a where condition is a string array

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