dapper cannot retrieve SqlGeometry

[terenceng2010]

Issue:

SqlGeometry intersectionPoint = conn.ExecuteScalar<SqlGeometry>(strSql, new { STREET1 = street1, STREET2 = street2 });

and it throw "Object must implement IConvertible"

Solution:

You need to ensure to use a working Microsoft.SqlServer.Types version.

With trial-and-error, it is found that:
if you are pointing to SQL Server 2012 or 2019,
you may use Microsoft.SqlServer.Types v11

Also, you must add the following to the connection string:

Type System Version=SQL Server 2012

Extra issue:
https://blog.developer.money/dapper-%E4%BD%BF%E7%94%A8-microsoft-sqlserver-types-%E6%89%BE%E4%B8%8D%E5%88%B0%E6%AD%A3%E7%A2%BA%E7%89%88%E6%9C%AC%E5%95%8F%E9%A1%8C-a7848b95b6e5