DataBase datetime null handle

Question

i have the following code:

var distinctRows = 
      (from row in ds.GetTable(this.TagShortName).AsEnumerable()
         select new Audit    
          {
             ID =row.Field<long>("ID"),
             UpdatedBy =string.Format("{0} {1}", 
                                      row.Field<string>("UpdatedByFirstName"),
                                      row.Field<string>("UpdatedByLastName")),
             UpdatedOn = ow.Field<DateTime>("UpdatedOn")
          }).Distinct(new AuditComparer());

when i have null value in UpdateOn field it throw exception on:

UpdatedOn =row.Field<DateTime>("UpdatedOn")

exception: Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type.

how to handle this?

Well what is UpdatedOn datatype you will need that to be DateTime? — V4Vendetta
– V4Vendetta, Commented Apr 11, 2013 at 9:00

Damith · Accepted Answer · 2013-04-11 09:08:09Z

1

Make UpdatedOn nullable or

UpdatedOn = row.Field<DateTime?>("UpdatedOn")?? DateTime.MinValue

edited Apr 11, 2013 at 9:08

answered Apr 11, 2013 at 8:59

Damith

63.2k13 gold badges106 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Habib · Accepted Answer · 2013-04-11 08:55:06Z

0

Use Nullable<DateTime> or DateTime?

UpdatedOn = row.Field<DateTime?>("UpdatedOn")

answered Apr 11, 2013 at 8:55

Habib

224k30 gold badges420 silver badges446 bronze badges

4 Comments

Nomi Ali Over a year ago

row.Field<DateTime?>("UpdatedOn") not working i already try this. how to use Nullable<DateTime> in my case?

Habib Over a year ago

@NomiAli, Nullable<DateTime> is same as DateTime?, the later is just syntactic suger, you need to make sure that your UpdatedOn is also defined as DateTime?, or you need to check it against null and then assign UpdatedOn some default value.

Kenan Kocaerkek Over a year ago

Make sure UpdatedOn defined Nullable in entity data model.

Nomi Ali Over a year ago

thanks man! actually my UpdatedOn was not nullable in entity. Thanks for the answers.

Collectives™ on Stack Overflow

DataBase datetime null handle

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related