/C#/.net entities query multiple join condition type inference

.net entities query multiple join condition type inference

var query = (from RR in context.TableOne
             from M in context.TableTwo 
             where RR.OrderedProductId == M.ProductID
                   || RR.SoldProductId == M.ProductID // Your join
             where RR.CustomerID == CustomerID 
                   && statusIds.Any(x => x.Equals(RR.StatusID.Value))
             select RR.OrderId).ToArray();

Source: entityframework.net

Similar codes

2 votes282 views1 answer
How to draw text in monogame
C#
0 vote256 views1 answer
Asp.net mvc get current url in view
C#
1 vote251 views1 answer
C# declare an int list
C#
1 vote301 views1 answer
UnityWebRequest get returned data
C#Unity
0 vote267 views1 answer
Check shell command success
C#
1 vote274 views1 answer
Xamarin button text lowercase
C#
0 vote312 views1 answer
Unity occulision for hide something
C#Unity
0 vote267 views1 answer
C# remove newline from string
C#
6 votes316 views2 answers
Unity rotate vector around point
C#Unity
1 vote257 views1 answer
Unity put children in list
C#