/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

3 votes118 views1 answer
Mouse button hold unity
C#
0 vote109 views1 answer
All SQL Server Tables in a Schema
C#
6 votes64 views3 answers
C# create directory
C#
0 vote119 views1 answer
Mouse click unity raycast unity
C#
-1 vote101 views1 answer
Increment and decrement in c#
C#
0 vote109 views1 answer
Datagridview show noti each row column
C#
4 votes131 views1 answer
Unity replace a text in a string
C#
0 vote123 views1 answer
How to get angular on visual studio mac
C#
0 vote115 views1 answer
How to get the ip asp.net mvc
C#
-1 vote102 views1 answer
Page refresh on button click in c#
C#