Posts
1150
Comments
891
Trackbacks
1
LINQ to SQL : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This annoying error when calling SubmitChanges() from a LINQ to SQL DataContext can occur if you are using a default value for a DateCreated DateTime column which is NOT NULL, and you add a table to the LINQ to SQL designer.  For whatever reason, it doesn’t pick up that it has a default value, so you need to highlight the column and go to properties, and manually set the ‘Auto Generated Value’ property to ‘True.’

posted on Friday, July 10, 2009 6:35 PM Print
Comments
Gravatar
# re: LINQ to SQL : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
yutthana
11/13/2009 9:39 AM
Thank you help me so much
Gravatar
# re: LINQ to SQL : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
Tom
1/18/2013 4:46 PM
Excellent, thanks!
Gravatar
# re: LINQ to SQL : SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
Elson
2/22/2016 11:30 AM
Finalmente alguem solucionou meu problema. Muito Obrigado!

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 3 and 3 and type the answer here: