score:2

Accepted answer
dim atquery = from e in entitycontext.vwsecappaudittoday
   order by e.date_occurred, e.time_occurred
   select new with {
      .dateoccurred = e.date_occurred,
      .timeoccurred = e.time_occurred,
      .servername = e.server_name
}

dim q2 = from e in atquery.toarray()
         select new auditentry with {
             .eventtime = datetime.parseexact(trim(e.dateoccurred) & trim(e.timeoccurred), "yyyymmddhhmmss", cultureinfo.invariantculture),
             .servername = e.servername
}

Related Query

More Query from same tag