C# (CSharp) SqlServer.Converters.SqlServerHierarchyIdTypeConverter Examples

Example #1

File: SqlHierarchyIdTests.cs Project: ServiceStack/ServiceStack.OrmLite

        public new void TestFixtureSetUp()
        {
            base.TestFixtureSetUp();

            var converter = new SqlServer.Converters.SqlServerHierarchyIdTypeConverter();
            ColumnDefinition = converter.ColumnDefinition;
        }

Example #2

        public new void TestFixtureSetUp()
        {
            base.TestFixtureSetUp();

            var converter = new SqlServer.Converters.SqlServerHierarchyIdTypeConverter();

            ColumnDefinition = converter.ColumnDefinition;
        }

Example #3

        public void Can_convert_hierarchyid_to_quoted_string()
        {
            var converter = new SqlServer.Converters.SqlServerHierarchyIdTypeConverter();

            string stringValue = null;
            var    hierarchyId = SqlHierarchyId.Parse(stringValue); // NULL
            var    str         = converter.ToQuotedString(typeof(SqlHierarchyId), hierarchyId);

            Assert.AreEqual($"CAST(null AS {ColumnDefinition})", str);

            stringValue = "/1/1/3/";
            hierarchyId = SqlHierarchyId.Parse(stringValue); // 0x5ADE
            str         = converter.ToQuotedString(typeof(SqlHierarchyId), hierarchyId);

            Assert.AreEqual($"CAST('{stringValue}' AS {ColumnDefinition})", str);
        }

Example #4

File: SqlHierarchyIdTests.cs Project: ServiceStack/ServiceStack.OrmLite

        public void Can_convert_hierarchyid_to_quoted_string()
        {
            var converter = new SqlServer.Converters.SqlServerHierarchyIdTypeConverter();

            string stringValue = null;
            var hierarchyId = SqlHierarchyId.Parse(stringValue); // NULL
            var str = converter.ToQuotedString(typeof(SqlHierarchyId), hierarchyId);

            Assert.AreEqual($"CAST(null AS {ColumnDefinition})", str);

            stringValue = "/1/1/3/";
            hierarchyId = SqlHierarchyId.Parse(stringValue); // 0x5ADE
            str = converter.ToQuotedString(typeof(SqlHierarchyId), hierarchyId);

            Assert.AreEqual($"CAST('{stringValue}' AS {ColumnDefinition})", str);
        }