kwh3856
asked on
How do you write a LINQ statement with multiple or's
I am trying to search a table but want to use an OR logic instead of the and logic in my statment. Can someone show me the correct syntax to turn this into OR logic?
var ProviderResult = from providerdata in dcRadRelay.PROVIDERs
where providerdata.FIRST_NAME == tbDocFname.Text &&
providerdata.LAST_NAME = tbDocLname.Text &&
providerdata.CITY = tbDocCity &&
providerdata.STATE = tbDocState &&
providerdata.ZIP = tbDocZip
select new { userdata };
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
from providerdata in dcRadRelay.PROVIDERs where providerdata.FIRST_NAME == tbDocFname.Text || providerdata.LAST_NAME == tbDocLname.Text || providerdata.CITY == tbDocCity || providerdata.STATE == tbDocState || providerdata.ZIP == tbDocZip
ASKER
Thank you very much.
Open in new window