This question already has an answer here:
How to compare only date components from DateTime in EF?
I cant seem to get my query to check the database if a date exists. Please help.
DateTime value = new DateTime(2018, 10, 26);
item = await table.Where(todoItem => todoItem.Date == value.date)
I think the format which c# writes their dates and SQL are different so it cant find a match. Also the database is correctly linked to the app as I am able to query other rows in the same table.