/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 vote285 views1 answer
Asp.net core mvc not triggering client side validation
C#
1 vote287 views1 answer
New parameterized thread c#
C#
-5 votes293 views5 answers
Happy New Year!
C#
0 vote257 views1 answer
C# tell if list object is empty
C#
4 votes287 views2 answers
Byte array to hex c#
C#
29 votes297 views3 answers
Unity key detection
C#
0 vote287 views1 answer
Xamarin 12 hrs time format tt
C#
0 vote294 views1 answer
Wpf how to focus on element
C#
0 vote321 views1 answer
Unity customize hierarchy window
C#Unity
0 vote318 views1 answer
Check if process is open c#
C#