Entity Framework setting Auto DateTime Column to: 01/01/0001 00:00:00

I have a MS SQL Srver 2005 Database, that has a table with a DatTime column. The DateTime column is of smalldatetime type. The date and time is auto generated by the DB using getdate() function. This is because its a LOG recording table, so logs are just inserted and date-time is generated by the db.

When creating a log and saving into the DB through Entity Framework, using LINQ query, it causes an error while saving saying:

"SqlDateTime overflo开发者_开发问答w. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."

upon investigating using breakpoints i have noticed, when Entity Framework tries to save the Log object, the date set by Entity Framework is set to:

01/01/0001 00:00:00

I guess this is why error is coming up. Is there any way to resolve this?

I am using .Net 3.5 framework.

Regards.

In EDMX change StoreGeneratedPattern for your date property to Computed. Be awere that there was a bug (not sure if the bug is already fixed) where changing this property in designer affected only CSDL part of EDMX file. You also need to add it to SSDL part.