Add support for NetTopologySuite
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
Research direction
Start by inspecting the existing SqlServer.Types support in FSharp.Data.SqlClient and the type-provider paths that handle SQL Server values. Check how NetTopologySuite is supported by Dapper and Entity Framework Core, then determine the project’s supported extension path for spatial or custom types. Done means NetTopologySuite spatial data can be used with the type provider on dotnetcore without relying on Microsoft.SqlServer.Types.
Written by the indexing model from the issue text.
Description
Description
In the past this type provider had support for SqlServer.Types a big part of which are the Spatial Data Types for SQLServer.
Today with the move to dotnetcore Microsoft.SqlServer.Types are no longer supported (only full framework). Dapper and Entityframework core both support NetTopologySuite as a replacement for the Geometry Sql Server Types. This library is much more widely supported and feature complete.
In order once again support Spatial Data Types, and to gain parity with other popular dotnet SQL libraries FSharp.Data.SqlClient should also support Spatial Data Types via NetTopologySuite.
Repro steps
Installing Microsoft.SqlServer.Types shows a warning that the package may not be fully compatible with your project.
Expected behavior
I would expect a path to use Spatial Data Types or support for custom types.
Actual behavior
It is not currently possible to use NetTopologySuite with this type provider.
Known workarounds
Use a different library.
Related information
- Database: SQL Server 2019
- Framework: dotnetcore 2.1
- Dominant language
- F#
- Stars
- 206
- Forks
- 66
- PR merge metrics
- No merged PRs in 30d
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from fsprojects/FSharp.Data.SqlClient
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
-
fsprojects/FSharp.Data.SqlClient#484 · 3 comments · 1 assignee ·
-
enhancement question
Difficulty 5/5 Over a week Newbie friendliness 25/100
fsprojects/FSharp.Data.SqlClient#445 · 9 comments ·
-
enhancement
Difficulty 5/5 Over a week Newbie friendliness 45/100
fsprojects/FSharp.Data.SqlClient#429 · 5 comments ·
-
bug
fsprojects/FSharp.Data.SqlClient#428 · 2 comments · 1 assignee ·
All issues in fsprojects/FSharp.Data.SqlClient
Similar issues
-
[6.x]: "Cannot use object of type stdClass as array" loading Users index (regression of #19182) Open
Difficulty 1/5 Under an hour Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
community-scripts/ProxmoxVE#17396 · 1 comment ·
-
bug possible-duplicate
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
AOSSIE-Org/PictoPy#1553 · 4 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
BasedHardware/omi#15274 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100