Entity framework not inserting values into nullable datetime field

Question

I can't save values into two nullable columns.

This is the entity I'm saving:

  nquote_orderheaders header = new nquote_orderheaders()
            {
                CreatedDate = DateTime.Now,
                SendDate = DateTime.Now,
                SentByUser = accountInfo.Username,
                CreatedByUser = accountInfo.Username,
                QuoteOrderNumber = tempQuoteNumber,
                IMCustomerNumber = resellerInfo.CustomerNo,
                CustomerEmail = accountInfo.Username,
                CustomerName = resellerInfo.CustomerName,
                UserComment = "",
                StatusId = 1,
                CustomerId = data.CustomerId,
                ExpirationDate = DateTime.Now.AddDays(14)
            };

The SendDate and ExpirationDate fields are nullable Datetimes. They end up null in the database.

I'm using MySql with MySqlConnector 6.5.4. Any suggestions greatly appreciated.

I don't know about MySqlConnector, maybe it's very picky about matching types. You may try to set nullable DateTime values: SendDate = new Nullable<DateTime>(DateTime.Now). — Gert Arnold
– Gert Arnold, Commented Oct 30, 2013 at 21:34

user3495888 · Accepted Answer · 2014-04-04 11:50:22Z

2

You have to cast DateTime.Now to the Nullable just like the following code:

CreatedDate = DateTime.Now as DateTime?,

or using longer form:

CreatedDate = DateTime.Now as Nullable<DateTime>,

answered Apr 4, 2014 at 11:50

user3495888

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

1 Comment

Mickael Caruso Over a year ago

Still saves a null date.

Collectives™ on Stack Overflow

Entity framework not inserting values into nullable datetime field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related