Link to home
Start Free TrialLog in
Avatar of jbajaj
jbajaj

asked on

linq to sql query for extract email which is not in string array

i have array like

string[] email=new string[]{"aa@aa.com","aa1@aa.com"}

now i need to extract all record which does not contail this emails.

Avatar of naspinski
naspinski
Flag of United States of America image

I don't understand the question.  I see that you have an array of emails - are you using this to search through a DB that has an email field and you want the records that are *not* in the array?

For example if your array is { "a@email.com", "b@email.com" }

and you table is:
EMAIL
a@email.com
b@email.com
c@email.com
d@email.com

You want the query to return c@email and d@email.com?
ASKER CERTIFIED SOLUTION
Avatar of naspinski
naspinski
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial