system.LinQ.Iqueryable(of date) cannot be converted to date

Question

Hello, I am trying to fetch data using linQ as shown below.

dim rerun as datetime

     Dim q = (From a In dashboard Where a.SucessFlag = 0 And a.ApplicationID = 1 _
                            Select a.logDate)
                rerunDate = q

I am getting this system.LinQ.Iqueryable(of date) cannot be converted to date

Any workaround will be greatly appreciated.

Answer 1

If you expect just one result just use Single or SingleOrDefault to get the date. If you want the first result you can use First or FirstOrDefault.