如何修复“SqlException:将 datetime2 数据类型转换为 datetime 数据类型导致值超出范围". [英] How to fix "SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value."

问题描述

SqlException:将 datetime2 数据类型转换为 datetime 数据类型导致值超出范围.

SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

我的代码是这样的:

        using (var contxt = new realtydbEntities())
        {
            var status = GetStatus();

            var repIssue = new RepairIssue()
            {
                CreaterId = AuthorId,
                RepairItemDesc = this.txtDescription.Text,
                CreateDate = DateTime.Now,//here's the problem
                RepairIssueStatu = status
            };

            contxt.AddObject("RepairIssues", repIssue);
            contxt.SaveChanges();
        }

CreateDate 属性映射到类型为 smalldatetime 的列.

the CreateDate property mapping to a column which type is smalldatetime.

如何让这段代码运行?

推荐答案

问题的根源在于 C# DateTime 对象比 SQL 的 smalldatetime 类型大".这是差异的一个很好的概述:http://karaszi.com/the-ultimate-guide-to-the-datetime-datatypes

The root of your problem is that the C# DateTime object is "bigger" than SQL's smalldatetime type. Here's a good overview of the differences: http://karaszi.com/the-ultimate-guide-to-the-datetime-datatypes

所以你的选择是:

1. 将列类型从 smalldatetime 更改为 datetime(或 datetime2)
2. 不要使用 EF，而是构建您自己的 SQL 命令(并且您可以使用 SqlDateTime)

这篇关于如何修复“SqlException:将 datetime2 数据类型转换为 datetime 数据类型导致值超出范围".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！