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.
string[] email=new string[]{"aa@aa.com","aa1@
now i need to extract all record which does not contail this emails.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?