/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 vote122 views1 answer
How to make an ui to follow gameobject
C#
3 votes127 views2 answers
Transform.Translate unity
C#
38 votes122 views3 answers
C# console delete last character
C#
0 vote145 views1 answer
Csvhelper driver c# nuget
C#
0 vote129 views1 answer
MailChimp C# Api calls
C#
0 vote114 views1 answer
Building a config object in XML C#
C#
0 vote141 views1 answer
How to combine constructors in c#
C#
2 votes123 views1 answer
How to find how much digits in number c#
C#
0 vote118 views1 answer
How to trigger event when a com device is connected in c#
C#
0 vote149 views1 answer
C# crud observablecollection -mvvm
C#