/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 vote137 views1 answer
Mvc session key exists
C#
0 vote151 views2 answers
Get last id ef
C#
1 vote190 views1 answer
Unity mesh showing Instance
C#Unity
1 vote181 views1 answer
What is data encapsulation c#
C#
0 vote173 views1 answer
Remove numericUpDown white space
C#
0 vote148 views1 answer
Mvc dotnet core how does the view pass parameters to controler
C#
28 votes145 views3 answers
C# system.io check if file exists
C#
0 vote161 views2 answers
C# linq unique by property
C#
0 vote163 views1 answer
Gersener waves
C#
2 votes211 views1 answer
How to change the position of a gameobject in c# unity
C#Unity