NLite.Data.Test.DateTimeTest.TestDateTimeDateDiffMillisecondNew C# (CSharp) Method

        public virtual void TestDateTimeDateDiffMillisecondNew()
        {
            DateTime dt = new DateTime(1997, 8, 25, 0, 0, 0);
            DateTime dt1 = new DateTime(1996, 1, 15, 10, 20, 30);
            var expected = (dt - dt1).Milliseconds;
            var actual = db.Orders.Select(o => o.OrderDate == dt && SqlFunctions.DateDiff(DateParts.Millisecond, o.OrderDate, dt1) == expected).FirstOrDefault();
            Assert.IsNotNull(actual);

            //溢出
            //var expected1 = (dt - dt1).TotalMilliseconds;
            //var item = db.Orders.Where(o => o.OrderDate == dt && SqlMethods.DateDiffMillisecond(dt1, o.OrderDate) == (int)expected1).FirstOrDefault();
            //Assert.IsNotNull(item);
        }