/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

14 votes119 views2 answers
Find and delete files c#
C#
0 vote127 views1 answer
Check if two timespans intersect c#
C#
0 vote124 views2 answers
Generate jwt token authorize(roles = admin ) not working .net core 403
C#
7 votes153 views2 answers
How to reference text mesh pro unity
C#
1 vote124 views1 answer
Unity gameobject.findobjectswith tag set active
C#
0 vote125 views2 answers
For c#
C#
0 vote116 views2 answers
Combobox in datagrid wpf
C#
18 votes132 views3 answers
Get random from list c#
C#
1 vote113 views1 answer
C# add strings
C#
2 votes133 views1 answer
How to reset rotation in unity
C#Unity