setting default value for code only

Question

How do u set default value for a property at the database level using Code-Only

For instance if i have a property called CreateDate and i want its default value in the database to be getdate(), how do i do it. or also another example be select newid() for guids..

Zeeshan

Answer 1

Hi Zeeshan,

Code First doesn't currently provide a mechanism for providing column default values.

You will need to manually modify the generated DDL to add them.

Cheers,

Andrew.

Answer 2

Alternatively, you could probably set the default value in your POCO's constructor:

 

public class MyBaseClass

{


 public MyBaseClass()

{

DateCreated = DateTime.Now;

}

 public Datetime DateCreated { get; set; }

}