C# (CSharp) SqlDateTimeOffset Examples

Example #1

File: SqlDateTimeOffsetTests.cs Project: camilohe/unQuery

        public void GetRawValue()
        {
            SqlType type = new SqlDateTimeOffset(testValue, 2, ParameterDirection.Input);
            Assert.AreEqual(testValue, type.GetRawValue());

            type = new SqlDateTimeOffset(null, 0, ParameterDirection.Input);
            Assert.Null(type.GetRawValue());
        }

Example #2

File: SqlDateTimeOffsetTests.cs Project: ffMathy/unQuery

        public void GetRawValue()
        {
            SqlType type = new SqlDateTimeOffset(testValue, 2, ParameterDirection.Input);

            Assert.AreEqual(testValue, type.GetRawValue());

            type = new SqlDateTimeOffset(null, 0, ParameterDirection.Input);
            Assert.Null(type.GetRawValue());
        }

Example #3

File: SqlDateTimeOffsetTests.cs Project: camilohe/unQuery

        public void CreateMetaData()
        {
            Assert.Throws<TypeCannotBeUsedAsAClrTypeException>(() => SqlDateTimeOffset.GetTypeHandler().CreateMetaData("Test"));

            SqlTypeHandler col = new SqlDateTimeOffset(testValue, null, ParameterDirection.Input);
            Assert.Throws<TypePropertiesMustBeSetExplicitlyException>(() => col.CreateMetaData("Test"));

            col = new SqlDateTimeOffset(testValue, 5, ParameterDirection.Input);
            var meta = col.CreateMetaData("Test");
            Assert.AreEqual(SqlDbType.DateTimeOffset, meta.SqlDbType);
            Assert.AreEqual(5, meta.Scale);
            Assert.AreEqual("Test", meta.Name);
        }

Example #4

File: SqlDateTimeOffsetTests.cs Project: ffMathy/unQuery

        public void CreateMetaData()
        {
            Assert.Throws <TypeCannotBeUsedAsAClrTypeException>(() => SqlDateTimeOffset.GetTypeHandler().CreateMetaData("Test"));

            SqlTypeHandler col = new SqlDateTimeOffset(testValue, null, ParameterDirection.Input);

            Assert.Throws <TypePropertiesMustBeSetExplicitlyException>(() => col.CreateMetaData("Test"));

            col = new SqlDateTimeOffset(testValue, 5, ParameterDirection.Input);
            var meta = col.CreateMetaData("Test");

            Assert.AreEqual(SqlDbType.DateTimeOffset, meta.SqlDbType);
            Assert.AreEqual(5, meta.Scale);
            Assert.AreEqual("Test", meta.Name);
        }

Example #5

File: SqlDateTimeOffsetTests.cs Project: ffMathy/unQuery

 public void CreateParamFromValue()
 {
     Assert.Throws <TypeCannotBeUsedAsAClrTypeException>(() => SqlDateTimeOffset.GetTypeHandler().CreateParamFromValue("Test", null));
 }

Example #6

File: SqlDateTimeOffsetTests.cs Project: ffMathy/unQuery

 public void GetTypeHandler()
 {
     Assert.IsInstanceOf <SqlTypeHandler>(SqlDateTimeOffset.GetTypeHandler());
 }