How to convert data type System.Data.Entity.Spatial.DbGeography to C #?

Question

How to convert data type System.Data.Entity.Spatial.DbGeography to C #?

Navigation

#1 by (1 votes)
#2 by (0 votes)

2

My table in DB named SqlSpatialType is as follows:

IDCliente int
Nombre Varchar
GpsLocation Geography
EuclideanaLocation  Geometry

My form

and I want to insert records using EntityFrameworK from C #, The problem I have is how to transform the length and latitude entered by the client ... into the correct data type

protected void Button1_Click(object sender, EventArgs e)
    {
        EMCEntities1 Modelo = new EMCEntities1();
        using (Modelo)
        {
            SqlSpatialType Location = new SqlSpatialType();
            Location.Nombre= txtName.Text;

            // AQUI MI PROBLEMA
            Location .GpsLocation = ? ;
            Location.EuclideanaLocation= ? ;

            Modelo.SqlSpatialType.Add(Location);
            Modelo.SaveChanges();
        }
    }

c# asp.net entity-framework sqldatatypes

asked by Efrain Mejias C 09.11.2016 в 14:15

source

2 answers

Uncaught TypeError: Can not read property '3' of undefined Random data in Blade / Laravel 5.1

score 1 · Answer 1

1

What data do you want to put in the GpsLocation field? I'm asking because I think the type you're looking for can be GeographyPoint instead of Geography . If so, GeographyPoint has a Create (Double, Double)

answered by 09.11.2016 в 15:33

0

What I did was the following

 protected void Button1_Click(object sender, EventArgs e) 
        {
            EMCEntities1 Modelo = new EMCEntities1();
            using (Modelo)
            {
                SqlSpatialType Location = new SqlSpatialType();
                Location.Nombre= txtName.Text;
                string longitud = txtLongitud.Text;
                string latitud = txtLatitud.Text;
                string puntoGeografico = "POINT( " + longitud + " " + latitud + ")";
                Location.GpsLocation =  System.Data.Entity.Spatial.DbGeography.FromText(puntoGeografico , 4326);
                Location.EuclideanaLocation = System.Data.Entity.Spatial.DbGeometry.FromText(puntoGeografico , 4326);
                Modelo.SqlSpatialType.Add(Location);
                Modelo.SaveChanges();
            }
        }

answered by 09.11.2016 в 18:03

score 0 · Answer 2

What I did was the following

 protected void Button1_Click(object sender, EventArgs e) 
        {
            EMCEntities1 Modelo = new EMCEntities1();
            using (Modelo)
            {
                SqlSpatialType Location = new SqlSpatialType();
                Location.Nombre= txtName.Text;
                string longitud = txtLongitud.Text;
                string latitud = txtLatitud.Text;
                string puntoGeografico = "POINT( " + longitud + " " + latitud + ")";
                Location.GpsLocation =  System.Data.Entity.Spatial.DbGeography.FromText(puntoGeografico , 4326);
                Location.EuclideanaLocation = System.Data.Entity.Spatial.DbGeometry.FromText(puntoGeografico , 4326);
                Modelo.SqlSpatialType.Add(Location);
                Modelo.SaveChanges();
            }
        }