Make GeoJSON plugin compatible with global mapping (#4662)

roji · web-flow · commit 92bd22dfa681 · 2022-09-15T11:07:44.000+02:00
Fixes #4661
diff --git a/src/Npgsql.GeoJSON/Internal/GeoJSONTypeHandlerResolver.cs b/src/Npgsql.GeoJSON/Internal/GeoJSONTypeHandlerResolver.cs
@@ -30,18 +30,21 @@ internal GeoJSONTypeHandlerResolver(NpgsqlConnector connector, GeoJSONOptions op
             ? default : CRSMaps.GetOrAdd(connector.Settings.ConnectionString, _ =>
             {
                 var builder = new CrsMapBuilder();
-                using (var cmd = connector.CreateCommand(
-                           "SELECT min(srid), max(srid), auth_name " +
-                           "FROM(SELECT srid, auth_name, srid - rank() OVER(ORDER BY srid) AS range " +
-                           "FROM spatial_ref_sys) AS s GROUP BY range, auth_name ORDER BY 1;"))
-                using (var reader = cmd.ExecuteReader())
-                    while (reader.Read())
-                    {
-                        builder.Add(new CrsMapEntry(
-                            reader.GetInt32(0),
-                            reader.GetInt32(1),
-                            reader.GetString(2)));
-                    }
+                using var cmd = connector.CreateCommand(
+                    "SELECT min(srid), max(srid), auth_name " +
+                    "FROM(SELECT srid, auth_name, srid - rank() OVER(ORDER BY srid) AS range " +
+                    "FROM spatial_ref_sys) AS s GROUP BY range, auth_name ORDER BY 1;");
+                cmd.AllResultTypesAreUnknown = true;
+                using var reader = cmd.ExecuteReader();
+
+                while (reader.Read())
+                {
+                    builder.Add(new CrsMapEntry(
+                        int.Parse(reader.GetString(0)),
+                        int.Parse(reader.GetString(1)),
+                        reader.GetString(2)));
+                }
+
                 return builder.Build();
             });
 
