Solved

LINQ DateTime save is not working when field need to be null

Posted on 2011-09-07

1 solution

Medium Priority

262 Views

Last Modified: 2012-05-12

I am currently trying to save a record to a sql server express database. One of the fields is a DateTime field that needs to be null upon record creation. For some reason, even though the linq object that represents the data has a null value set for the record, I keep getting a SqlDateTime error indicating that the date enter should be between 1753 and ......., forgot the max range. Anyway, if I am setting this field as null why is this occuring and what can I do to fix it(workarounds)?

Comment

Question by:rawcoder

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 23

Expert Comment

by:wdosanjos

ID: 364955522011-09-07

For the field to accept null values it should be defined as DateTime? not DateTime.

LVL 4

Accepted Solution

by:guramrit

guramrit earned 2000 total points

ID: 364968192011-09-07

There're two reasons for this error to occur.
1. In database, you didn't set the column with datetime datatype to Allow Null
2. In code, you'd forgot to set a value to some other column with datetime datatype.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Beginning OOP: How to implement and call Interfaces with a conflicting method name in same Class

Article by: gopaltayde

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…

SQL CLR .Net Integration in 2015 (year not product version)

Article by: Éric

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…

.NET Programming

Microsoft Bookings Review

Video by: Lisa

This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

How to run like The Flash in Adobe After Effects

Video by: John

This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…