/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

1 vote100 views1 answer
Unity custom editor save changes
C#
0 vote55 views1 answer
How to read key from web config in JavaScript
C#
2 votes111 views1 answer
Ef select multiple items
C#
0 vote86 views1 answer
Remove tag anchor and inside tag from html raw text c#
C#
0 vote103 views3 answers
Reporting Progress from Async Tasks c#
C#
3 votes93 views1 answer
Unity get project file directory
C#
11 votes106 views1 answer
How to make a hello world program in c#
C#
3 votes102 views1 answer
Initialization synonym
C#
2 votes165 views1 answer
How to clone something unity
C#Unity
0 vote103 views1 answer
Solr Binary Field to byte[]
C#