{"action":"created","issue":{"url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/16","repository_url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types","labels_url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/16/comments","events_url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/16/events","html_url":"https://github.com/dotMorten/Microsoft.SqlServer.Types/issues/16","id":374927419,"node_id":"MDU6SXNzdWUzNzQ5Mjc0MTk=","number":16,"title":"SqlGeography.ToString() produce incorrect value","user":{"login":"MaceWindu","id":1099238,"node_id":"MDQ6VXNlcjEwOTkyMzg=","avatar_url":"https://avatars1.githubusercontent.com/u/1099238?v=4","gravatar_id":"","url":"https://api.github.com/users/MaceWindu","html_url":"https://github.com/MaceWindu","followers_url":"https://api.github.com/users/MaceWindu/followers","following_url":"https://api.github.com/users/MaceWindu/following{/other_user}","gists_url":"https://api.github.com/users/MaceWindu/gists{/gist_id}","starred_url":"https://api.github.com/users/MaceWindu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaceWindu/subscriptions","organizations_url":"https://api.github.com/users/MaceWindu/orgs","repos_url":"https://api.github.com/users/MaceWindu/repos","events_url":"https://api.github.com/users/MaceWindu/events{/privacy}","received_events_url":"https://api.github.com/users/MaceWindu/received_events","type":"User","site_admin":false},"labels":[{"id":900866592,"node_id":"MDU6TGFiZWw5MDA4NjY1OTI=","url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"closed","locked":false,"assignee":{"login":"dotMorten","id":1378165,"node_id":"MDQ6VXNlcjEzNzgxNjU=","avatar_url":"https://avatars1.githubusercontent.com/u/1378165?v=4","gravatar_id":"","url":"https://api.github.com/users/dotMorten","html_url":"https://github.com/dotMorten","followers_url":"https://api.github.com/users/dotMorten/followers","following_url":"https://api.github.com/users/dotMorten/following{/other_user}","gists_url":"https://api.github.com/users/dotMorten/gists{/gist_id}","starred_url":"https://api.github.com/users/dotMorten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dotMorten/subscriptions","organizations_url":"https://api.github.com/users/dotMorten/orgs","repos_url":"https://api.github.com/users/dotMorten/repos","events_url":"https://api.github.com/users/dotMorten/events{/privacy}","received_events_url":"https://api.github.com/users/dotMorten/received_events","type":"User","site_admin":false},"assignees":[{"login":"dotMorten","id":1378165,"node_id":"MDQ6VXNlcjEzNzgxNjU=","avatar_url":"https://avatars1.githubusercontent.com/u/1378165?v=4","gravatar_id":"","url":"https://api.github.com/users/dotMorten","html_url":"https://github.com/dotMorten","followers_url":"https://api.github.com/users/dotMorten/followers","following_url":"https://api.github.com/users/dotMorten/following{/other_user}","gists_url":"https://api.github.com/users/dotMorten/gists{/gist_id}","starred_url":"https://api.github.com/users/dotMorten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dotMorten/subscriptions","organizations_url":"https://api.github.com/users/dotMorten/orgs","repos_url":"https://api.github.com/users/dotMorten/repos","events_url":"https://api.github.com/users/dotMorten/events{/privacy}","received_events_url":"https://api.github.com/users/dotMorten/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2018-10-29T09:34:11Z","updated_at":"2018-10-29T15:30:12Z","closed_at":"2018-10-29T15:13:25Z","author_association":"NONE","body":"Thanks for your fixes! Our tests work now except one case below:\r\n```\r\n\r\n  Expected: \"LINESTRING (-122.36 47.656, -122.343 47.656)\"\r\n  But was:  \"LINESTRING (47.656 -122.36, 47.656 -122.343)\"\r\n```\r\n```cs\r\n[Test, IncludeDataContextSource(ProviderName.SqlServer2008, ProviderName.SqlServer2012, ProviderName.SqlServer2014, TestProvName.SqlAzure)]\r\n\t\tpublic void Test4(string context)\r\n\t\t{\r\n\t\t\tusing (var conn = new DataConnection(context))\r\n\t\t\t{\r\n\t\t\t\tusing (var cmd = conn.CreateCommand())\r\n\t\t\t\t{\r\n\t\t\t\t\tcmd.CommandText = \"SELECT Cast(geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326) as geography)\";\r\n\r\n\t\t\t\t\tAssert.That(cmd.ExecuteScalar().ToString(), Is.EqualTo(\"LINESTRING (-122.36 47.656, -122.343 47.656)\"));\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t}\r\n```"},"comment":{"url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/comments/433955757","html_url":"https://github.com/dotMorten/Microsoft.SqlServer.Types/issues/16#issuecomment-433955757","issue_url":"https://api.github.com/repos/dotMorten/Microsoft.SqlServer.Types/issues/16","id":433955757,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMzk1NTc1Nw==","user":{"login":"MaceWindu","id":1099238,"node_id":"MDQ6VXNlcjEwOTkyMzg=","avatar_url":"https://avatars1.githubusercontent.com/u/1099238?v=4","gravatar_id":"","url":"https://api.github.com/users/MaceWindu","html_url":"https://github.com/MaceWindu","followers_url":"https://api.github.com/users/MaceWindu/followers","following_url":"https://api.github.com/users/MaceWindu/following{/other_user}","gists_url":"https://api.github.com/users/MaceWindu/gists{/gist_id}","starred_url":"https://api.github.com/users/MaceWindu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaceWindu/subscriptions","organizations_url":"https://api.github.com/users/MaceWindu/orgs","repos_url":"https://api.github.com/users/MaceWindu/repos","events_url":"https://api.github.com/users/MaceWindu/events{/privacy}","received_events_url":"https://api.github.com/users/MaceWindu/received_events","type":"User","site_admin":false},"created_at":"2018-10-29T15:30:12Z","updated_at":"2018-10-29T15:30:12Z","author_association":"NONE","body":"Great! Now all our related tests pass!"}}
{"actor":{"display_login":"MaceWindu"}}