I have tried to get the build working at
https://github.com/suryapratap/Nhibernate.Spatial
please feel free to check it out/add more
On 4/11/2013 9:39 PM, nfplee wrote:
Hi, has anyone managed to get the NHibernate spatial stuff to work
with the latest version of NHibernate. I managed to rebuild the
project targeting the correct version of NHibernate after following:
http://build-failed.blogspot.co.uk/2012/02/nhibernate-spatial-part-1.html
My IGeometry field is mapped correctly as I can both query it and
insert/update it. However I have tried using one of the LINQ extension
methods by saying session.Query<Type>().Where(t =>
t.Fiedl1.Distance(t.Field2)).ToList();
But this gives the error:
"A .NET Framework error occurred during execution of user-defined
routine or aggregate \"geography\": \r\nSystem.ArgumentException:
24204: The spatial reference identifier (SRID) is not valid. The
specified SRID must match one of the supported SRIDs displayed in the
sys.spatial_reference_systems catalog
view.\r\nSystem.ArgumentException: \r\n at
Microsoft.SqlServer.Types.SqlGeography.set_Srid(Int32 value)\r\n at
Microsoft.SqlServer.Types.SqlGeography.Read(BinaryReader r)\r\n at
SqlGeography::.DeserializeValidate(IntPtr , Int32 , CClrLobContext*
)\r\n."
I know I have set the SRID correctly after following the instructions
in the post above. I have also made sure I have registered the spatial
linq to hql generators in the session factory.
I'd appreciate it if someone could let me know if it is compatible
with the latest version.
Thanks
Lee
--
---
You received this message because you are subscribed to the Google
Groups "nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
--
---
You received this message because you are subscribed to the Google Groups "nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
