Solved

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

Posted on 2011-09-07

1 solution

260 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 500 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

Suggested Solutions

Title	# Comments	Views	Activity
aspx ascx, c#	7	41	2017-04-26
Windows Universal App	22	58	2017-05-03
C# rename a class and update all references efficiently	6	52	2017-05-04
C# How to display the first five answers that have smallest value?	16	42	2017-05-08

Entity Framework and Store Procedures that return multiple resultsets

Article by: Alexandre

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!

DRY Exception Handling with PostSharp

Article by: Alexandre

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.

Improve Phase - 4.1 Simple Linear Regression

Video by: GreyCampus

Simple Linear Regression

Examples of Enumerating Permutations and Combinations

Video by: Ed

I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…