c# - Linq to sql not filtering result as expected -
i have following query:
string oversite = "ab"; var wherequery = result in t_staging_trts_mpmnmcp cutstrings.contains(result.tydlno) && result.source_system_instance.contains(oversite) select result; "oversite" string in instance "ab" "cutstrings list of strings
the problem i'm having query return results outside of oversite. "aa", "ac", "ad"
i have tried:
&& result.source_system_instance == oversite why && seem act || (and seems act or?)
Comments
Post a Comment