/// <summary>
/// Initializes a new connection to PostGIS
/// </summary>
/// <param name="connectionString">Connectionstring</param>
/// <param name="tablename">Name of data table</param>
/// <param name="objectIdColumnName">Name of column with unique identifier</param>
public PostGIS(string connectionString, string tablename, string objectIdColumnName)
: this(connectionString, tablename, "", objectIdColumnName)
{
int srid;
GeometryColumn = GetGeometryColumn(out srid);
SRID = srid;
if (!string.IsNullOrEmpty(GeometryColumn))
{
_postGisSpatialObject = GetSpatialObjectType();
SRID = GetGeometrySrid();
}
}
/// <summary>
/// Initializes a new connection to PostGIS
/// </summary>
/// <param name="connectionString">Connectionstring</param>
/// <param name="tablename">Name of data table</param>
/// <param name="geometryColumnName">Name of geometry column</param>
/// <param name="objectIdColumnName">Name of column with unique identifier</param>
public PostGIS(string connectionString, string tablename, string geometryColumnName, string objectIdColumnName)
{
ConnectionString = connectionString;
Table = tablename;
GeometryColumn = geometryColumnName;
if (!string.IsNullOrEmpty(geometryColumnName))
{
_postGisSpatialObject = GetSpatialObjectType();
SRID = GetGeometrySrid();
}
ObjectIdColumn = objectIdColumnName;
_postGisVersion = GetPostGISVersion();
_supportSTIntersects = _postGisVersion >= 1.3;
_supportSTMakeBox2d = _postGisVersion >= 1.4;
_supportSTMakeEnvelope = _postGisVersion >= 2.0;
if (_postGisVersion >= 1.5)
{
_prefixFunction = "ST_";
}
}
/// <summary>
/// Initializes a new connection to PostGIS
/// </summary>
/// <param name="connectionString">Connectionstring</param>
/// <param name="tablename">Name of data table</param>
/// <param name="objectIdColumnName">Name of column with unique identifier</param>
public PostGIS(string connectionString, string tablename, string objectIdColumnName)
: this(connectionString, tablename, "", objectIdColumnName)
{
int srid;
GeometryColumn = GetGeometryColumn(out srid);
SRID = srid;
if (!string.IsNullOrEmpty(GeometryColumn))
{
_postGisSpatialObject = GetSpatialObjectType();
SRID = GetGeometrySrid();
}
}
/// <summary>
/// Initializes a new connection to PostGIS
/// </summary>
/// <param name="connectionString">Connectionstring</param>
/// <param name="tablename">Name of data table</param>
/// <param name="geometryColumnName">Name of geometry column</param>
/// <param name="objectIdColumnName">Name of column with unique identifier</param>
public PostGIS(string connectionString, string tablename, string geometryColumnName, string objectIdColumnName)
{
ConnectionString = connectionString;
Table = tablename;
GeometryColumn = geometryColumnName;
if (!string.IsNullOrEmpty(geometryColumnName))
{
_postGisSpatialObject = GetSpatialObjectType();
SRID = GetGeometrySrid();
}
ObjectIdColumn = objectIdColumnName;
_postGisVersion = GetPostGISVersion();
_supportSTIntersects = _postGisVersion >= 1.3;
_supportSTMakeBox2d = _postGisVersion >= 1.4;
_supportSTMakeEnvelope = _postGisVersion >= 2.0;
if (_postGisVersion >= 1.5)
_prefixFunction = "ST_";
}