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

        public virtual void TestDateTimeDateDiffMonth()
        {
            //DateTime aa = new DateTime(1997, 8, 25, 1, 2, 3, 102);
            //DateTime bb = new DateTime(1998, 9, 24, 4, 1, 1, 100);
            //Console.WriteLine((aa - bb).Hours);


            ////DateTime aa = new DateTime(1997, 8, 25, 1, 2, 3, 102);
            ////DateTime bb = new DateTime(1997, 8, 24, 1, 2, 3, 103);
            ////Console.WriteLine((aa - bb).Days);

            var actual = db.Orders.FirstOrDefault(o => o.OrderDate == new DateTime(1997, 8, 25) && SqlFunctions.DateDiff(DateParts.Month, o.OrderDate, new DateTime(1996, 1, 1)) == -19);
            Assert.AreNotEqual(null, actual);
        }