NHibernate.Spatial.MsSql

NHibernate.Spatial is a library of spatial extensions for NHibernate, and allows you to connect NHibernate to a spatially-enabled database and manipulate geometries in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.


Keywords
DAL, Database, GIS, GeoSpatial, NHibernate, NHibernate.Spatial, ORM, spatial, sql
License
LGPL-2.1-only
Install
Install-Package NHibernate.Spatial.MsSql -Version 8.0.0

Documentation

NHibernate.Spatial Build status

NHibernate.Spatial is a library of spatial extensions for NHibernate, and allows you to connect NHibernate to a spatially-enabled database and manipulate geometries in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.

NuGet Packages

Package Version
NHibernate.Spatial.MsSql NuGet Status
NHibernate.Spatial.MySQL NuGet Status
NHibernate.Spatial.PostGis NuGet Status
NHibernate.Spatial.SpatiaLite NuGet Status

Supported Databases

Package Dialects CI Tests
NHibernate.Spatial.MsSql SQL Server 2012 SQL Server 2017, SQL Server 2019, SQL Server 2022
NHibernate.Spatial.MySQL MySQL 5.7, MySQL 8.0 MySQL 5.7, MySQL 8.0, MySQL 8.3
NHibernate.Spatial.PostGis PostGIS 2.0, PostGIS 3.0 PostGIS 2.5 (PostgreSQL 12), PostGIS 3.0 (PostgreSQL 12), PostGIS 3.4 (PostgreSQL 16)
NHibernate.Spatial.SpatiaLite SpatiaLite SpatiaLite 4, SpatiaLite 5

Getting Started

For configuring your application, please refer to Configuration and Mapping on the NHForge Wiki. Furthermore you can read about sample usage. For an updated in-depth look at NHibernate.Spatial, you can read this excellent blog post written by Pedro Sousa.

For general NHibernate help, the NHibernate community website - http://nhibernate.info/ - has a range of resources to help you get started with basic NHibernate, including wikis, blogs and reference documentation.

SpatiaLite

In order to use the SpatiaLite dialect, the mod_spatialite.[dll|so] library must be available on the PATH. To assist with cases where mod_spatialite cannot be installed on the system PATH, the SpatiaLite driver prepends <path to NHibernate.Spatial.SpatiaLite.dll>/lib/spatialite to the PATH.

https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite

Discussion Forum

Discussion is made through the NHibernate.Spatial Mailing List. Feel free to join in with suggestions or thoughts!

Request for Contributors

All contributors are welcome. We need help improving the current dialects, getting tests to pass, identifying and fixing bugs, and keeping the project going.

Credits

Many thanks to the following individuals, organisations and projects whose work is so important to the success of NHibernate.Spatial (in no particular order):