예제 #1
0
        public void DateTimeOffsetYMDHMSmsTimeSpanConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int  = 9,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(2014, 1, 2, 3, 4, 5, testObject.Value_Int, TimeSpan.FromHours(-2.5)),
            })).Single();

            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(2014, 1, 2, 3, 4, 5, 9, TimeSpan.FromHours(-2.5))));
        }
예제 #2
0
        public void DateTimeOffsetDateTimeTimeSpanConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int  = 8,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 6), TimeSpan.FromHours(testObj.Value_Int)),
            })).Single();

            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 6), TimeSpan.FromHours(8))));
        }
예제 #3
0
        public void DateTimeOffsetTicksTimeSpanConstructor()
        {
            var value   = new DateTimeOffset(2014, 1, 2, 3, 4, 5, 6, TimeSpan.Zero);
            var testObj = new TestObject3()
            {
                Value_Int  = 8,
                Value_Long = value.UtcTicks,
            };
            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(testObject.Value_Long, TimeSpan.FromHours(-2.5))
            })).Single();

            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(testObj.Value_Long, TimeSpan.FromHours(-2.5))));
        }
예제 #4
0
        public void DateTimeOffsetDateTimeConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int  = 8,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, testObject.Value_Int)),
            })).Single();

            // this test is questionable because DateTimeOffset would normally be local in .NET, but we can't support
            // that server-side because we don't know the client-side's timezone in the expression tree.
            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 8), TimeSpan.Zero)));
        }
예제 #5
0
        public void LongAndIntTests()
        {
            var testObj = new TestObject3()
            {
                Id                  = 3,
                Value_Int           = 1354353535,
                Value_Int_Nullable  = 3,
                Value_Long          = 2222222222,
                Value_Long_Nullable = 2
            };

            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var to = connection.Run(testTable3.Get(3));

            Assert.That(to, Is.Not.Null);
            Assert.That(to.Id, Is.EqualTo(3));
        }
예제 #6
0
        public void DateTimeOffsetYMDHMSmsTimeSpanConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int = 9,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));
            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(2014, 1, 2, 3, 4, 5, testObject.Value_Int, TimeSpan.FromHours(-2.5)),
            })).Single();
            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(2014, 1, 2, 3, 4, 5, 9, TimeSpan.FromHours(-2.5))));
        }
예제 #7
0
        public void DateTimeOffsetTicksTimeSpanConstructor()
        {
            var value = new DateTimeOffset(2014, 1, 2, 3, 4, 5, 6, TimeSpan.Zero);
            var testObj = new TestObject3()
            {
                Value_Int = 8,
                Value_Long = value.UtcTicks,
            };
            var resp = connection.Run(testTable3.Insert(testObj));
            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(testObject.Value_Long, TimeSpan.FromHours(-2.5))
            })).Single();
            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(testObj.Value_Long, TimeSpan.FromHours(-2.5))));
        }
예제 #8
0
        public void DateTimeOffsetDateTimeTimeSpanConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int = 8,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));
            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 6), TimeSpan.FromHours(testObj.Value_Int)),
            })).Single();
            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 6), TimeSpan.FromHours(8))));
        }
예제 #9
0
        public void DateTimeOffsetDateTimeConstructor()
        {
            var testObj = new TestObject3()
            {
                Value_Int = 8,
                Value_Long = 2,
            };
            var resp = connection.Run(testTable3.Insert(testObj));
            Assert.That(resp.Inserted, Is.EqualTo(1));

            var result = connection.Run(testTable3.Map(testObject => new {
                DTO = new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, testObject.Value_Int)),
            })).Single();
            // this test is questionable because DateTimeOffset would normally be local in .NET, but we can't support
            // that server-side because we don't know the client-side's timezone in the expression tree.
            Assert.That(result.DTO, Is.EqualTo(new DateTimeOffset(new DateTime(2014, 6, 6, 6, 6, 8), TimeSpan.Zero)));
        }
예제 #10
0
        public void LongAndIntTests()
        {
            var testObj = new TestObject3()
            {
                Id = 3,
                Value_Int = 1354353535,
                Value_Int_Nullable = 3,
                Value_Long = 2222222222,
                Value_Long_Nullable = 2
            };

            var resp = connection.Run(testTable3.Insert(testObj));

            Assert.That(resp.Inserted, Is.EqualTo(1));

            var to = connection.Run(testTable3.Get(3));
            Assert.That(to, Is.Not.Null);
            Assert.That(to.Id, Is.EqualTo(3));
        }