Oracl GeoSPatial datatype Problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Wed 25 Aug 2010 18:59

Oracl GeoSPatial datatype Problem

Post by sdonka » Wed 25 Aug 2010 19:06


I have installed Dotconnect for Oralce and generated entity files.
When i was trying to query a table using Linq 2 sql which has a GeoSpatial Datatype called "ST_Geometry", I am getting an error stating that Invalid DataType : "ST_Geometry". When i run query within oracle database, it works fine.
How do i achieve this ? Also i tried executing actual sql statement, but still the error says the same.

You can find the generated code chunk :

[Column(Name = @"SHAPE", Storage = "_Shape", DbType = "ST_GEOMETRY")]
public Devart.Data.Oracle.OracleObject Shape
return this._Shape;
if (this._Shape != value)
this._Shape = value;

How do i full fill this, Please help in this regards

Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Fri 27 Aug 2010 11:07

Object types are not supported in LinqConnect. The possible way to work with them is to use general ADO.NET classes, like OracleCommand, and the OracleObject component that represents Oracle object types.

As for executing plain SQL statements, did you connect to Oracle in the Direct or OCI mode? Please note that Oracle objects can be used in the OCI connection mode only.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 31 Aug 2010 11:10

Take a look at this blog post. We describe the work with the spatial data in PostgreSQL in it. Hope this helps.

Post Reply