Set default value in EF designer datetime

Question

Trying to set the default value of a datetime field to take current time. In SQL's field designer i'd use getdate(). What should i use in Entity Framework's designer?

thx

Answer 1

Set 'StoredGeneratedPattern' to Computed against the field in the EDMX.

You still need the default value in SQL Server though, the above setting will ensure EF honour's that.

Answer 2

Building upon RPM1984's answer:

1. Select the field that has the default value,Created_On in my example, within your EDMX file
2. Go to the Properties panel
3. Select the StoreGeneratedPattern attribute
4. Then change the value to Computed