c# – 如何使用dapper将DbGeography插入SQL Server

public class Store
{
    public int Id { get; private set; }
    public string Name { get; set; }
    public string Address { get; set; }
    public DbGeography Location { get; set; }
}

插入数据库

using (SqlConnection conn = SqlHelper.GetOpenConnection())
{
    const string sql = "INSERT INTO Stores(Name,Address,Location) " + 
                       "VALUES (@Name,@Address,@Location)";
    return conn.Execute(sql,store);                                
}

我得到异常类型System.Data.Entity.Spatial.DbGeography不能用作参数值

我已经尝试过寻找插入的方法,this是我能找到的最好的,但它试图只插入1个参数,我该怎么做才能插入一个有dbgeography成员的对象？

更新#1

我已经放弃了试图破解或扩展内容,因为我对新手来说非常新,时间不在我身边.我回到基本这样做,因为我不需要非常频繁地进行地理数据类型插入

using (SqlConnection conn = SqlHelper.GetOpenConnection())
        {
            var sql = "INSERT INTO Stores (Name,IsActive,Location,TenantId) " +
                      "VALUES('@Name','@Address',@IsActive,geography::Point(@Lat,@Lng,4326),@TenantId);";

            return conn.Execute(sql,new 
            { 
                Name = store.Name,Address = store.Address,IsActive = store.IsActive,Lat = store.Location.Latitude.Value,Lng = store.Location.Longitude.Value,TenantId = store.TenantId
            });             
        }