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.

In Summary : Which spatial library should i use in c# to deal with what Mysql.Data gives me from a MariaDB database. Pointers to some resources would be helpful too.

Thanks for taking the time to read (and hopefully answer)