Which c# library should i use to handle spatial data from MySQl (MariaDB)
I have a long-standing c# app (circa 100k lines of code) that uses Mysql (MariaDB 10) as its backing database. I’m using the MySQL.Data library to access the database. The client has now asked me to incorporate spatial data. I had a quick play with NTS but it doesn’t like (or i’m doing it wrong) reading from GetMySqlGeometry when I try to pull data back using a datareader.
I have a little spatial knowledge but its not something i have used a lot. I will mostly be just capturing and storing the spatial data after some validation using a few ‘Contains’ and probably some ‘Distance Between’ to validate it. The client is going to be processing the data using Arc, R QGis and their own tools so I don’t need much functionality.
Switching database engine or provider isn’t an option, I need to integrate with what I have in place.
Which library should i use to handle spatial data in MySQl (MariaDB)
I have a long-standing c# app (circa 100k lines of code) that uses Mysql (MariaDB 10) as its backing database. I’m using the MySQL.Data library to access the database. The client has now asked me to incorporate spatial data. I had a quick play with NTS but it doesn’t like (or i’m doing it wrong) reading from GetMySqlGeometry when I try to pull data back using a datareader.
I have a little spatial knowledge but its not something i have used a lot. I will mostly be just capturing and storing the spatial data after some validation using a few ‘Contains’ and probably some ‘Distance Between’ to validate it. The client is going to be processing the data using Arc, R QGis and their own tools so I don’t need much functionality.
Switching database engine or provider isn’t an option, I need to integrate with what I have in place.