使用LINQ到SQL SubmitChanges()时，什么会导致SqlDateTime溢出? [英] What would cause a SqlDateTime overflow when using LINQ to SQL SubmitChanges()?

问题描述

在我的代码中，我向存储库添加了多个对象，我尝试在所有循环结束时运行存储库Save()函数一次，并在添加每个对象之后调用它.但是无论哪种方式，当存储库中的db.SubmitChanges().Save()...我仍然知道时，我仍然会收到SqlDateTime溢出?

In my code I have multiple objects being added to the repository, I have tried running the repository Save() function one time at the end of all the loops, and also calling it after every object that is added. But either way I still get a SqlDateTime overflow when the db.SubmitChanges() in the repository .Save()... any idea?

 SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Source Error:

Line 155:        public void Save()
Line 156:        {
Line 157:            db.SubmitChanges();
Line 158:        }
Line 159:


Source File: C:\inetpub\wwwroot\Models\OrderRepository.cs    Line: 157


        foreach (string vol in volumes)
        {
            if (vol != "-1" && vol != "")
            {
                Product prod = orderRepository.getProductByVolumeID(System.Convert.ToInt32(vol));
                ProductVolume pvol = orderRepository.getProductVolumeByID(System.Convert.ToInt32(vol));

                OrderProduct oProd = new OrderProduct();
                oProd.OrderID = getOrder.OrderID;
                oProd.VolumeID = pvol.VolumeID;
                orderRepository.AddOrderProduct(oProd);


            }
        }

        foreach (string feat in features)
        {
            if (feat != "")
            {
                Product prod = orderRepository.getProductByID(System.Convert.ToInt32(feat));

                OrderFeature oFeat = new OrderFeature();
                oFeat.OrderID = getOrder.OrderID;
                oFeat.ProductID = prod.ProductID;
                orderRepository.AddOrderFeature(oFeat);


                featuresTotal += prod.UserIntervalPrice;
            }

        }

        totalTotal = volumeTotal + featuresTotal;
        orderRepository.Save();

推荐答案

基本上，问题在于Sql DATETIME数据类型从1/1/1753开始，而DateTime.MinValue为1/1/0000(或类似的东西) ).因此，如果不初始化date属性，则会出现Sql溢出.

Basically, the issue is that the Sql DATETIME datatype starts at 1/1/1753, wheras DateTime.MinValue is 1/1/0000 (or something like that). So, if you don't initialize the date properties, you get Sql overflows.

修复选项:

a)在某处初始化DateTime.

a) Initialize the DateTime somewheres.

b)切换sql以使用DATETIME2数据类型，该数据类型确实覆盖了.NET DateTime值的整个范围. [仅适用于SQL 2008]

b) Switch sql to use the DATETIME2 datatype which does cover the whole range of .NET DateTime values. [SQL 2008 only]

这篇关于使用LINQ到SQL SubmitChanges()时，什么会导致SqlDateTime溢出?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！