C# ROQL Query Email Address
I have a list of customers email addresses that I want to query against the Contacts table in the Oracle Service Cloud. I basically want to see if the email address exists in the system, so I could just select the count and if it is greater than 0 that would give me what I need. I have attached my code. I am using a while loop to go through my email list.
SELECT count() FROM Contact WHERE (Contact.Emails.Address = '" + customers[i].email + "'OR Contact.Emails.Address = '" + customers[i].email + "'OR Contact.Emails.Address = '" + customers[i].email + "');