/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 vote126 views1 answer
Celsius to Fahrenheit c#
C#
5 votes111 views1 answer
Unity call a function every x seconds
C#
3 votes115 views2 answers
C# bytes to image
C#
31 votes125 views3 answers
C# adding to a list
C#
0 vote122 views1 answer
C# read file while writing
C#
0 vote125 views1 answer
How to add an embedded resource in visual studio code
C#
0 vote119 views1 answer
Largest prime factor C#
C#
3 votes74 views1 answer
Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
C#
0 vote127 views1 answer
C# solution path
C#
2 votes148 views1 answer
Enable script unity
C#Unity