/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 vote251 views1 answer
C# Search specified string inside textbox
C#
13 votes233 views2 answers
Unity convert float to decimal
C#Unity
-1 vote261 views1 answer
How to dynamically load value in startup file in c#
C#
0 vote270 views1 answer
How to add an assembly reference in c#
C#
2 votes209 views1 answer
Format phone number in c# .net
C#
0 vote235 views1 answer
How to get the current time in milliseconds .net
C#
26 votes238 views4 answers
Onkeypressed unity
C#Unity
0 vote256 views1 answer
C# return list
C#
0 vote230 views1 answer
C# enum to int array
C#
0 vote267 views1 answer
C# split large file into chunks
C#