Dapper With Geography

I'm trying to retrieve SQL Geography using dapper through Stored procedure, but it's gives error:
System.Data.DataException: 'Error parsing column 14 (GeoData=)'
InvalidCastException: Unable to cast object of type 'Microsoft.SqlServer.Types.SqlGeography' to type 'Microsoft.Data.SqlClient.Server.IBinarySerialize'.

Dapper.EntityFramework.Handlers.Register(); added to ConfigureServices in startup

also tried to add
`AssemblyLoadContext.Default.Resolving += Default_Resolving;

private static System.Reflection.Assembly Default_Resolving(AssemblyLoadContext assemblyLoadContext, System.Reflection.AssemblyName assemblyName)
{
try
{
AssemblyLoadContext.Default.Resolving -= Default_Resolving;
return assemblyLoadContext.LoadFromAssemblyName(assemblyName);
}
catch
{
if (assemblyName.Name == "Microsoft.SqlServer.Types")
return typeof(SqlGeography).Assembly;
throw;
}
finally
{
AssemblyLoadContext.Default.Resolving += Default_Resolving;
}
}`

• Dapper 2.0.123
• Dapper.EntityFramework 2.0.90
• .NET Core 6.0
• Microsoft.EntityFrameworkCore.Relational 6.0.3
• Microsoft.SqlServer.Types 14.0.1016.290
• NetTopologySuite.IO.GeoJSON 2.0.4

Begin by reproducing the stored-procedure query from ConfigureServices with Dapper 2.0.123, Dapper.EntityFramework 2.0.90, .NET 6, and Microsoft.SqlServer.Types 14.0.1016.290. Trace the GeoData column handling and the SqlGeography-to-IBinarySerialize cast, then verify that geography retrieval no longer raises the reported DataException.