Program.cs

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            Handlers.RegisterGeography();
            
            using (var conn = new SqlConnection(""))
            {
                string sql = @"
                        INSERT INTO Coordinates 
                        (Id, UserKey, CreateTime, Feature, UserType, MapId) 
                        VALUES 
                        (@Id, @UserKey, @CreateTime, @Feature, @UserType, @MapId)";

                var id = Guid.NewGuid();
                conn.Execute(sql,
                    new
                    {
                        Id = id,
                        UserKey = id.ToString(),
                        CreateTime = DateTimeOffset.Now,
                        Feature = new Point(122, 25) { SRID = 4326 },
                        UserType = 1,
                        MapId = new Guid("56DD6AA3-63C1-4CC2-8045-AAEA00C31B42")
                    });

                var data = conn.Query<Coordinate>("SELECT TOP 10 Id, Feature.Serialize() AS Feature FROM Coordinates");
            }
        }
    }
}