我已经创建了模型using System.Data.Entity.Spatial;
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);
}
我得到了例外type System.Data.Entity.Spatial.DbGeography cannot be used as a parameter value
我尝试寻找插入的方法,this https://stackoverflow.com/questions/6690565/using-dapper-with-sql-spatial-types-as-a-parameter是我能找到的最好的,但它试图仅插入 1 个参数,我应该怎么做才能插入具有 dbgeography 成员的对象?
更新#1
我已经放弃了尝试修改或扩展东西,因为我对短小精悍还很陌生,而且目前时间不在我这边。我回到了基本的做法,因为我不需要经常进行地理数据类型插入
using (SqlConnection conn = SqlHelper.GetOpenConnection())
{
var sql = "INSERT INTO Stores (Name, Address, 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
});
}