开发者

LINQ - How to insert null DateTime into database column?

开发者 https://www.devze.com 2023-03-20 02:07 出处：网络

Using LINQ, how do I insert a null value into a SQL Server 2008 DateTime column? The code below inserts \"1/1/1900 12:00:00 AM\",

相关专题：linq linq-to-sql

Using LINQ, how do I insert a null value into a SQL Server 2008 DateTime column?

The code below inserts "1/1/1900 12:00:00 AM", But I want to insert "NULL" instead

Cre开发者_StackOverflow中文版atDate = System.Data.SqlTypes.SqlDateTime.Null

Ensure that the column in the DB is set to allow NULL and your entity property, "CreateDate" is defined as "DateTime? CreateDate {get;set;}". Then, simply set "CreateDate = null".

Your CreateDate property needs to be declared Nullable<DateTime> (aka DateTime?). Then, you can set that property on your Linqed-up object to null (not System.Data.SqlTypes.SqlDateTime.Null, just plain old C# null) and you should get the desired result. This of course assumes that your SQL table has the column properly defined to allow NULLs and that your definition for the column in the DBML also allows them.