dotconnect for postgresql v 6.7 spatial mapping issue.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
locus
Posts: 3
Joined: Wed 03 Jul 2013 08:40

dotconnect for postgresql v 6.7 spatial mapping issue.

Post by locus » 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotconnect for postgresql v 6.7 spatial mapping issue.

Post by Shalex » Tue 06 Aug 2013 13:20


Post Reply