C# (CSharp) SqlServer.Converters.SqlServerGeographyTypeConverter 예제들

예제 #1

파일: SqlGeographyTests.cs 프로젝트: ServiceStack/ServiceStack.OrmLite

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

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

예제 #2

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

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

            ColumnDefinition = converter.ColumnDefinition;
        }

예제 #3

        public void Can_convert_SqlGeography_to_quoted_string()
        {
            var converter = new SqlServer.Converters.SqlServerGeographyTypeConverter();

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

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

            stringValue = "POINT(0 0)";
            location    = SqlGeography.Parse(stringValue);
            stringValue = location.ToString(); // to fix any whitespace issues

            str = converter.ToQuotedString(typeof(SqlGeography), location);

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

예제 #4

파일: SqlGeographyTests.cs 프로젝트: ServiceStack/ServiceStack.OrmLite

        public void Can_convert_SqlGeography_to_quoted_string()
        {
            var converter = new SqlServer.Converters.SqlServerGeographyTypeConverter();

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

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

            stringValue = "POINT(0 0)";
            location = SqlGeography.Parse(stringValue);
            stringValue = location.ToString(); // to fix any whitespace issues

            str = converter.ToQuotedString(typeof(SqlGeography), location);

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