Oracl GeoSPatial datatype Problem

sdonka · Post by **sdonka** » Wed 25 Aug 2010 19:06

Hi,

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
{
get
{
return this._Shape;
}
set
{
if (this._Shape != value)
{
this.OnShapeChanging(value);
this.SendPropertyChanging();
this._Shape = value;
this.SendPropertyChanged("Shape");
this.OnShapeChanged();
}
}
}

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

StanislavK · 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.

AndreyR · 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.