/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 vote158 views1 answer
Make an object disappear from a c# script unity
C#
0 vote184 views1 answer
Clickable table row asp.net core cursor
C#
0 vote162 views1 answer
Opération inter-threads non valide
C#
0 vote160 views1 answer
Chaine de connexion sql server c#
C#
0 vote228 views1 answer
C# check control type
C#
5 votes175 views1 answer
C# change cursor
C#
2 votes176 views2 answers
Save file tar.gz c#
C#
0 vote191 views1 answer
How to update custom package in unity
C#
0 vote169 views1 answer
Count Rows of table using Linq
C#
3 votes179 views1 answer
Difference two list c#
C#