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

Tag: linq-to-sql Author: haoxvesheng Date: 2009-09-21

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.

Other Answer1

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.