Resolved issue with Dynamics SDK condition operators for Contains and Not contains, so all tests passing. WHERE clause conditions now work properly with Joins.