how to use more than one condition in ef join
var query = from x in context.table1
join y in context.table2 on
new {
Key1 = x.col1,
Key2 = x.col2,
Key3 = true,
Key4 = true
}
equals
new {
Key1 = y.key1,
Key2 = y.key2,
Key3 = y.from_date< DateTime.Now,
Key4 = !y.deleted
}
into result
from r in result.DefaultIfEmpty()
select new {x.Something, r.Something}
Also in C#:
- question mark operator in c#
- c# discord bot
- Unity if object doens't exist
- unity left mouse button
- c# post request
- unity onclick object
- get string character by index c#
- c# get today's date
- unity cycle children
- null coalesce ternary c#
- c# save pdf to folder
- asp.net mvc 5 codefirst dropdown list
- how to close a form c#
- how to find the area of a circle
- populate combobox from array c#
- c# variable
- c# console delay
- how to convert object in string JSON c#
- c# webrequest cookies
- On add component unity
- unity how to change the text on a button
- Linq - Random Elements
- unity how to change rotation
- what is a protected int c#