Devart Forums

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

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.

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