linq query .net core join with multiple conditions code example
Example: .net entities query multiple join condition
var query = (from x in context.table1
join y in context.table2 on new {x.col1, x.col2} equals {b.key1, b.key2}
into result
query = from x in query
where ...