Get total count of sql records of matched date

Question

I'm trying to return a count of records from a database with today's date, using entity framework. I think my query is ok, if you take a look at the screenshot record 2 is the only item out of the 3 with todays date, which is correct.

How can i return a count. Currently its returning a bool value

Thank you

       Dim today = DateTime.Today.Date
       Dim todaysBuild = retrieveOrders.[Select](Function(build) build.TimeAndDate >= today).ToList()

EDIT:

 Dim todaysBuild = retrieveOrders.Where(Function(build) build.TimeAndDate >= today).ToList()

alwaysVBNET · Accepted Answer · 2017-03-13T10:25:17.963

1

The variable todaysBuild is a list. You need the count (Integer) of that list so add the .Count at the end of your code.

  Dim todaysBuild = retrieveOrders.[WHERE](Function(build) build.TimeAndDate >= today).ToList.Count

edited Mar 13 '17 at 10:25

answered Mar 13 '17 at 10:02

alwaysVBNET

3,150
8
32
65

Thanks, i did try count instead of list but not both. – A Houghton Mar 13 '17 at 10:10
@AHoughton Yes, you need to add a WHERE clause. See this: http://stackoverflow.com/questions/6359980/proper-linq-where-clauses – alwaysVBNET Mar 13 '17 at 10:21
@AHoughton try replacing the [SELECT] with [WHERE] – alwaysVBNET Mar 13 '17 at 10:24

Get total count of sql records of matched date

1 Answers1