public void Post([FromBody] LocalViewModel value)
{
var local = new Local
{
Nome = value.Nome
};
ctx.Add(local);
ctx.SaveChanges();
var update = $"Update Locais set Ponto = geography::STGeomFromText('POINT ('+@lng+' '+@lat+')', 4326) WHERE id = @id";
ctx.Database.ExecuteSqlCommand(update,
new SqlParameter("id", local.Id),
new SqlParameter("lng", value.Location.Lng.ToString()),
new SqlParameter("lat", value.Location.Lat.ToString())
);
}
