views:

316

answers:

2

Hi

Has any one know a way to use nHibernate with database tables that coontains ESRI's st_geometry columns?

This corrently prevents us the usage with nHibernate in our applications.

Thanks

A: 

For Nhibernate GIS operations use NTS NetTopologySuite. It has the interfaces IGeometry , IPoint etc.

You can manipulate spatial datastructures with these libraries

Cherian
A: 

you can use NHibernate.Spatial to work with those columns. i successfully used nHibernate.Spatial with SQL Server 2008 and geometry/geography columns.

nHibernate.Spatial uses GeoAPI and NTS NetTopologySuite too as Cherian stated in the previous answer.

Joachim Kerschbaumer
Thanks for the replayWe use Oracle as our database, so we can't use NHibernate.Spatial - it doesn't support Oracle for now.According to what I read in the docs, NHibernate spatial supports only the native geographic types in SqlServer 2008 and not esri's type...
you could try to implement a custom type as an IUserType and doing the conversion for yourself
Joachim Kerschbaumer