/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

9 votes189 views3 answers
Null coalescing operator c#
C#
0 vote294 views1 answer
1/1/1/1/1
C#
0 vote185 views1 answer
C# string to enum conversion
C#
0 vote172 views1 answer
Unity game object remove parent
C#
7 votes322 views1 answer
Unity 2d jump
C#Unity
0 vote168 views1 answer
How to find the multiples of 3 c#
C#
0 vote177 views1 answer
Fpdf c#
C#
28 votes164 views4 answers
How to add data in list in c#
C#
0 vote245 views1 answer
Customize yup number
C#
0 vote217 views2 answers
Wpf datagrid get selected items
C#