/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

4 votes169 views3 answers
Sum of digits in c#
C#
0 vote160 views1 answer
How to access asp button of gridview
C#
0 vote163 views1 answer
Get connectionstring from web config c#
C#
0 vote176 views1 answer
C# string .contains against empty string returns
C#
2 votes156 views1 answer
Calling stored procedure in c# entity framework
C#
0 vote150 views1 answer
Compiling C# Example
C#
0 vote163 views1 answer
Muovere un elemento in c#
C#
1 vote146 views1 answer
C# for loop increment by 2
C#
0 vote156 views2 answers
Make command prompt hidden c#
C#
0 vote164 views1 answer
Visual studio c# mark class deprecated
C#