Adding a where t

I have a Query class with IJoin Interfaces

public class MyQuery : QueryDb<MyItem>, IJoin<MyItem, Join1>

The problem I am facing is that the Join actually needs 2 columns to make the join distinct. I know I can do it using a join with an expression but that would add an additional reference in the expression.

The biggest problem is that it is currently giving me a cartesian that is killing performance.

Is there a way to change the join on the existing expression to add the additional join columns?

My apologies I am a little foggy today. Disregard I can just add a where condition Where<MyItem, Join1> () blah blah.

Sorry for the waste of time.

1 Like