-1

I have a Linq Query like this

var db = new Models.Mydb();

        var model = from c in db.VW_myTable

         select new { COdUser = c.CodUser, Entrada = c.StartHour, Salida = c.EndHour, fecha = c.DATE };

When i get Null values in the DATE field I need to replace those null values with a DateTime.now

HHungria
  • 481
  • 4
  • 6

1 Answers1

2

Try this : 

var model = from c in db.VW_myTable
            select new 
            { 
              COdUser = c.CodUser, 
              Entrada = c.StartHour, 
              Salida = c.EndHour, 
              fecha = c.DATE ?? DateTime.Now 
            };

Check this post for a detailed explanation about ?? operator.

Community
  • 1
  • 1
kelsier
  • 4,050
  • 5
  • 34
  • 49
  • I used var model = from c in db.VW_myTable select new { COdUser = c.CodUser, Entrada = c.StartHour, Salida = c.EndHour, fecha = c.DATE == null ? c.DATE: DateTime.Now }; – HHungria Oct 23 '14 at 16:42
  • @user2752018 So no errors? I need to know the data type of `DATE` column? Also give me some sample values from the table `VW_myTable`? – kelsier Oct 24 '14 at 05:26