dotconnect for postgresql v 6.7 spatial mapping issue.
Posted: Wed 31 Jul 2013 13:47
I get the following error when I try to change the type of one property in my model to Geometry:
"Member Mapping specified not valid. The type 'Edm.Geometry [Nullable=True, DefaultValue=,SRID=0,IsStrict=False]' of member (...) is not compatible with 'Devart.Data.PostgreSQL.geometry [Nullable=True,DefaultValue=,MaxLength=2147483646,FixedLength=False]' of Member (...)"
The reason I want to change the mode type to a geometry type instead of binary is because when I use binary it seems like the SRID is always set to 0 when it is transferred to the database, even though I specify the srid to be 4326 when I make a spatial point (e.g. DbGeometry.PointFromText("POINT (1 1)", 4326).AsBinary(); )
So how to I upload spatial types to a postgreSQL postGIS enabled database without losing the SRID data on the way?
Thanks
"Member Mapping specified not valid. The type 'Edm.Geometry [Nullable=True, DefaultValue=,SRID=0,IsStrict=False]' of member (...) is not compatible with 'Devart.Data.PostgreSQL.geometry [Nullable=True,DefaultValue=,MaxLength=2147483646,FixedLength=False]' of Member (...)"
The reason I want to change the mode type to a geometry type instead of binary is because when I use binary it seems like the SRID is always set to 0 when it is transferred to the database, even though I specify the srid to be 4326 when I make a spatial point (e.g. DbGeometry.PointFromText("POINT (1 1)", 4326).AsBinary(); )
So how to I upload spatial types to a postgreSQL postGIS enabled database without losing the SRID data on the way?
Thanks