EF - pass null value to SQL column so default value gets inserted

SQL Server table T2 has 2 columns:

Id INT NOT NULL
CreateDate DateTime NOT NULL, default = (getdate())


This statement inserts the CreateDate value correctly because it uses (getdate()) as default.

Insert T2 (Id)
Values (1)


So far so good. The problem is when I use Entity Framework to insert a row and still wish to use the default (getdate()) value.

getdate()

Because the CreateDate is defined as NOT NULL, I cannot leave it blank or leave out of the Insert statement when using EF. But I want SQL to generate the timestamp on the server/database side.

CreateDate

NOT NULL

Is there a way to handle this?

1 Answer
1

Thanks to squillman's reference to another SO post, I was able to find the answer.

Go to EDMX diagram, and you can set the StoreGeneratedPattern property to achieve what I am trying to do.

There are three Database Generated Options

Computed : The database generates a value when a row is inserted or updated.
Identity : The database generates a value when a row is inserted.
None : The database does not generate values.


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.