/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 vote170 views2 answers
How to close a form c#
C#
0 vote168 views1 answer
Wpf set image source in code behind
C#
1 vote221 views1 answer
Unity know when gameobject presed
C#Unity
0 vote175 views1 answer
Call class c#
C#
3 votes157 views1 answer
Unity Exit application
C#
0 vote163 views1 answer
How to set the value of a textbox textmode=date asp.net c#
C#
0 vote161 views3 answers
Reporting Progress from Async Tasks c#
C#
1 vote180 views1 answer
C# set a guid
C#
10 votes223 views4 answers
Unity rotate around point
C#Unity
9 votes263 views1 answer
Camera follow
C#