/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

1 vote258 views1 answer
Get self component in unity
C#
3 votes293 views1 answer
Mailkit send attachment
C#
0 vote255 views1 answer
C# generate insert statement from object
C#
0 vote256 views1 answer
HtmlToPdfConverter
C#
2 votes264 views1 answer
C# read csv file
C#
0 vote277 views1 answer
How to round to nearest number in array c#
C#
1 vote241 views1 answer
C# distinct array of objects by values
C#
0 vote220 views1 answer
Get unix time in seconds C#
C#
0 vote258 views2 answers
Unity 2d top down movement script
C#
0 vote275 views1 answer
Unity set parent canvas
C#Unity