/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 vote198 views3 answers
How to check url has parameter in c#
C#
1 vote235 views1 answer
Get all devices in game unity
C#Unity
4 votes202 views1 answer
C# create DataTable
C#
0 vote203 views1 answer
Unity customize hierarchy window
C#
0 vote189 views1 answer
C# codebehind Append div
C#
0 vote194 views1 answer
How to check if data already exists in database in c# mvc
C#
0 vote192 views1 answer
Get Last Access Time Of Directory C#
C#
0 vote198 views2 answers
Getawaiter and no extension method
C#
1 vote230 views1 answer
Convert request.form to dictionary c#
C#
1 vote190 views1 answer
C# change colour of console
C#