/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

2 votes279 views2 answers
Remove from list based on condition c#
C#
0 vote308 views1 answer
Create shortcut C# WPF
C#
0 vote313 views1 answer
Unity add explosion force
C#
0 vote322 views1 answer
C# encode jpg hiight quality
C#
0 vote290 views1 answer
List of countries in .net mvc 5
C#
-1 vote267 views1 answer
C# get regedit value
C#
2 votes313 views1 answer
Cursor not visible unity c#
C#Unity
13 votes295 views2 answers
Boostrap 4 modal
C#
28 votes328 views3 answers
Unity check gameobject active
C#Unity
0 vote290 views1 answer
How to pass function as paraemter of another function pythpn
C#