How do I can combine the results in this LINQ query?
c.field == 1 below generates results and c.field == 3 generates results but how can I show the list of both results together. This below generates no results. I guess one is cancelling out the other.
var today = DateTime.Now.Date;
var tomorrow = today.AddDays(1);
var query = from c in databasetable
where c.date > today && c.date < tomorrow
&& c.field == 1
&& c.field == 3