/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 vote132 views2 answers
C# 2d list
C#
0 vote149 views1 answer
Fix autofill issue asp.net mvc
C#
0 vote142 views2 answers
Array reduce c#
C#
1 vote135 views1 answer
Vscode not showing errors c#
C#
0 vote155 views1 answer
Debug output to console and a log
C#
1 vote130 views1 answer
C# const string array
C#
2 votes138 views1 answer
Increase variable C#
C#
1 vote155 views2 answers
Convert memorystream to byte array c#
C#
1 vote142 views1 answer
West of loathing
C#
0 vote172 views2 answers
Forloop counting backwards csharp
C#