/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

0 vote100 views1 answer
Linq string comparison case insensitive
C#
0 vote96 views1 answer
List contains type c#
C#
1 vote80 views1 answer
Unity main texture not working
C#Unity
-1 vote94 views1 answer
Unity public script
C#
-1 vote90 views1 answer
Increment and decrement in c#
C#
0 vote98 views1 answer
C# clear label text
C#
24 votes137 views2 answers
How to destroy an object in unity
C#Unity
0 vote96 views1 answer
C# get the return value of a func
C#
0 vote161 views1 answer
Unity magnetize a 3d object to cursor
C#Unity
2 votes129 views1 answer
Unity 2d how to set an object or the mouse position
C#Unity