DBConfigurationBase Class |
Base class for classes that interact with the database.
Inheritance HierarchySystemObject
Cadcorp.DataAccessDbDatabase
Cadcorp.Configuration.ConnectorsDBConfigurationBase
Cadcorp.Configuration.ConnectorsSQLiteConfigConnector
Cadcorp.DataAccessDbDatabase
Cadcorp.Configuration.ConnectorsDBConfigurationBase
Cadcorp.Configuration.ConnectorsSQLiteConfigConnector
Namespace: Cadcorp.Configuration.Connectors
Assembly: Cadcorp.Configuration (in Cadcorp.Configuration.dll) Version: 9.0.2618.0 (9.0.2618.0)
SyntaxThe DBConfigurationBase type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | DBConfigurationBase |
Creates new instance of DBConfigurationBase
|
Properties| Name | Description | |
|---|---|---|
 | ConnectionString |
Database connection string to use
|
| Provider |
Database provider.
|
Methods| Name | Description | |
|---|---|---|
| AddDeleteWMSLayerLookup |
Add or delete a wms layer lookup
|
| AddIcon |
Adds a new icon to the site.
|
| AddNewMap |
Adds a new map to the site.
|
| AddOSOpenNamesSearch |
Adds OS Searches to Search_OS_Places tables
|
| AddOSPlacesSearch |
Adds OS Searches to Search_OS_Places tables
|
| AddProxy |
Adds a proxy to the admin database.
|
| AddResolution |
Adds a resolution to the database for specified map.
|
| AddUpdateAccessConnection |
Adds or updates an Access Connection String.
|
| AddUpdateAdditionalGeognoSIS8Layer |
Add an AdditionalGeognoSIS8Layer to the system, or update an existing one.
|
| AddUpdateAdditionalWMSLayer |
Add an additional WMS Layer, or update an existing WMS additional layer.
|
| AddUpdateBingLayer |
Adds a Bing layer to the system, or updates an existing one.
|
| AddUpdateCRS |
Adds or updates a CRS Values in the database.
|
| AddUpdateGeognoSIS8Layer |
Adds a new GeognoSIS 8 layer to the site, or updates an existing layer.
|
| AddUpdateGeognoSISTileServiceLayer |
Add a new GeognoSIS Tile Service Layer to the system. or update an existing one.
|
| AddUpdateGoogleLayer |
Adds a new Google Layer to the system, or updates an existing one.
|
| AddUpdateLocalKnowledge |
Adds a new local knowledge entry to the site, or updates an existsing entry.
|
| AddUpdateNoticeBoard |
Adds a notice board to the system or updates an existing notice board.
|
| AddUpdateNoticeBoardColumn |
Adds a column to a notice board, or updates an existing column.
|
| AddUpdateNoticeBoardLayer |
Adds a layer to a notice, or updates an existing notice.
|
| AddUpdateNoticeBoardNotice |
Adds a notice to a notice board, or updates an existing notice.
|
| AddUpdateOracleConnection |
Adds or updates an Oracle Connection String.
|
| AddUpdateOSMLayer |
Adds a new OSM layer to the system, or updates an existing layer.
|
| AddUpdatePostGisConnection |
Adds or updates an PostGIS Connection String.
|
| AddUpdateReportIt |
Adds or Updates a ReportIt record in the database.
|
| AddUpdateSingleSearch | |
| AddUpdateSQLiteConnection |
Adds or updates an SQLite Connection String.
|
| AddUpdateSQLServerConnection |
Adds or updates an SQL Server Connection String.
|
| AddUpdateTemplate |
Adds or updates a template within the system.
|
| AddUpdateTileCacheLayer |
Add a tile cache to the system, or update an existing layer.
|
| AddUpdateWebServiceConnection |
Adds or updates an Web Service String.
|
| AddUpdateWFSLayer |
Add a WFS Layer to the system, or update an existing layer.
|
| AddUpdateWMSFromCapabilitiesLayer |
Add a WMS From Capabilities Layer, or update an existing layer.
|
| AddUpdateWMSFromCapabilitiesUrls |
Add URL for WMS From Capabilities Layer, or update exisitng URL
|
| AddUpdateWMSLayer |
Add a WMS Layer, or update an existing WMS additional layer.
|
| AddUpdateWMSOverlayUrls |
Add or delete a wms url
|
| AddUpdateWMTSLayer |
Add a new WMTS layer to the site, or update an existing layer.
|
| AddUpdateXYZLayer |
Add an XYZ layer to the site, or update an existing xyz layer.
|
| AddWatermark |
Method to add watermark to the database.
|
| CheckAddConnectorInfo |
Updates the database with connector information.
|
| CheckAddCredential |
Check or add a credential to the database.
|
| CheckAddGeognoSISTileServiceLayerLookup |
Check to see if a GeognoSISTileServiceLayerLookup value exists, if not, add it.
|
| CheckAddIn |
Check to see if an AddIn exists in the database.
|
| CheckAddKnownProjection |
Check or add a known projection to the database.
|
| CheckAddLayer |
Check to see if a layer exists, if not, add it.
|
| CheckIfLocalKnowledgeIsInUse |
Performs an operation to see if the local knowledge entry is in use by a map.
|
 | CreateReturnParameter |
Adds a return parameter to non query.
(Inherited from DbDatabase.) |
| DeleteIcon |
Deletes an icon from the site.
|
| DeleteResolution |
Delete a resolution from the database.
|
| DeleteWatermark |
Deletes a watermark from the site.
|
| DuplicateSearch |
Copies a search
|
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetAdapter | (Inherited from DbDatabase.) |
| GetAddIns |
Gets available add ins.
|
| GetAddInsForMap |
Gets available Add Ins for a specified map.
|
| GetAllBingOverlayTypes |
Returns a list of available bing map overlay types.
|
| GetAllExtents |
Gets all available map extents.
|
| GetAllGoogleLayerTypes |
Gets all available Google Layer Types
|
| GetAllIcons |
Gets all available Icons.
|
| GetAllImageFormats |
Gets all available Image Formats
|
| GetAllNoticeBoards |
Gets array of NoticeBoard data.
|
| GetAllOSSearchDataByMapName |
Returns OS APIs searches configured for a map
|
| GetAllPhotometricInterpretations |
Gets all available Photometric Interpretations
|
| GetAllProblemTypes |
Get Problem Types.
|
| GetAllProjections |
Gets a list of available projections from the database.
|
| GetAllReportItConfigurations |
Gets All ReportIt data.
|
| GetAllSingleSearchData |
Gets all the single search data.
|
| GetAllSingleSearchDataByMapName |
Gets all the single search data.
|
| GetAllStyleMapNames |
Gets the names of all available Style Maps.
|
| GetAllStyleMaps |
Gets all available Style Maps
|
| GetAllStyles |
Gets available styles.
|
| GetAllStylesByMapNameAndIntent |
Gets all styles for a map name and intent.
|
| GetAllTemplates |
Gets available templates.
|
| GetAllTransitionEffects |
Gets all available Transition Effects.
|
| GetAllUrls |
Gets all available URLs as DataTable.
|
| GetAllWatermarks |
Gets available Watermarks.
|
| GetAppSettings |
Gets the app settings for the site.
|
| GetBookmarks |
Gets available bookmarks for requested Map.
|
| GetConnectionStrings |
Get available Connection Strings.
|
| GetControls |
Gets available controls for supplied map name.
|
| GetCredentialByLayerId |
Gets credentials based on layer id, for use with authenticated proxy layers.
|
| GetCRSValues |
Get Array of CRS values.
|
| GetDbCommand |
Creates a new command object.
(Inherited from DbDatabase.) |
| GetDbConnection |
Creates a new connection object.
(Inherited from DbDatabase.) |
| GetDbDataAdapter |
Creates a new adapter object.
(Inherited from DbDatabase.) |
| GetDBParameterString |
Returns the correct parameter string for the database platform in use.
(Inherited from DbDatabase.) |
| GetDBSearchConfiguration |
Get the configuration dataset for a noticeboard database search
|
| GetDBUppercaseFunction |
Returns the correct parameter string for the database platform in use.
(Inherited from DbDatabase.) |
| GetDBWildcardString |
Returns the correct parameter string for the database platform in use.
(Inherited from DbDatabase.) |
| GetDefaultMap |
Get Map Settings for default map.
|
| GetDefaultMapName |
Get Name of default map.
|
| GetDistinctResolutionsNoMap |
Gets available distinct resolutions.
|
| GetDrawingStyles |
Gets drawing styles for supplied map name.
|
| GetEditingStyles |
Gets editing styles for supplied map name.
|
| GetEmbeddableMapConfiguration |
Gets the map configuration for an embeddable map.
|
| GetFrontTemplate |
Gets the front template table entries for supplied map name.
|
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetHighestGoogleOverlayIndex |
Gets the index of the highest Google Overlay
|
| GetHighestTileCacheOverlayIndex |
Gets the highest z index available for Tile Cache Overlays for specified map.
|
| GetHighestWFSOverlayIndex |
Gets the highest z index available for WFS Overlays for specified map.
|
| GetHighestXYZOverlayIndex |
Gets the higest Z index for XYZ Overlays in the specified map
|
| GetImageFormat |
Gets the Image Format name based on the supplied ImageFormatID
|
| GetImageFormatIDFromName |
Gets the Image Format ID from the name provided.
|
| GetKnownProjections |
Gets Known Projections for supplied map name.
|
| GetLastCreatedRowID |
Get Last Created Row ID
|
| GetLayer |
Gets a layer name based on the supplied LayerID.
|
| GetLayers |
Gets layers associated with a WMS.
|
| GetLocalknowledgeConfiguration |
Gets Local Knowledge Configuration DataSet.
|
| GetLocalknowledgeConfiguration(Int32) | |
| GetLocalKnowledgeData |
Gets Local Knowledge data.
|
| GetLocalKnowledgeLayerTemplates |
Gets layer templates for local knowledge id.
|
| GetMap |
Get Map Settings for requested Map Name
|
| GetMapDescriptions |
Gets map summaries for the requested maps
|
| GetMapExtent |
Gets Map Extent string for specified map.
|
| GetMapFontSizes |
Gets available Map Font Sizes for map name.
|
| GetMapIcons |
Gets map Icons for supplied map name.
|
| GetMapIDFromMapName |
Gets the map ID from the supplied map name.
|
| GetMaps |
Gets available maps.
|
| GetMeasuringStyles |
Gets measuring styles for supplied map name.
|
| GetNoticeBoardConfiguration |
Get the configuration dataset for a noticeboard
|
| GetOsOpenNameFilterTypes |
Returns a list with all available filter types from Search_OS_Open_Name_Filter_Type
|
| GetOverlayIcons |
Get all available overlay icons for requested map.
|
| GetOverlays |
Gets overlays available for specified map.
|
| GetParameter(String, Object, String) |
Returns a new parameter.
(Inherited from DbDatabase.) |
| GetParameter(String, Object, String, Boolean) | (Inherited from DbDatabase.) |
| GetPhotometricInterpretationIDFromName |
Gets the Photometric Interpretation ID from the name provided.
|
| GetPrintTemplatesForMap |
Gets print templates for the map.
|
| GetProblemTypes |
Get Problem Types for a specified report ID.
|
| GetProjectionIDFromName |
Gets the Projection ID from the name provided.
|
| GetProjections |
Gets all available Projections.
|
| GetProjectionsByMapName |
Gets all available Projections based on map name.
|
| GetProxyConfiguration |
Gets available Proxy Configurations.
|
| GetReport |
Gets a report for the report name specified.
|
| GetReportItConfiguration |
Gets ReportIt data for the admin system.
|
| GetResolutions |
Gets available resolutions for requested Map.
|
| GetScales |
Gets available scales for requested Map.
|
| GetSearches |
Get available Searches.
|
| GetSearchesForMap | |
| GetSearchPermissionsForMap |
Gets search permissions for the map.
|
| GetStyleMapIDFromName |
Gets the Style Map ID from the name provided.
|
| GetStylesByStyleMapID |
Gets available styles for requested Style Map ID.
|
| GetTemplates |
Gets DataSet of available Templates.
|
| GetTransitionEffect |
Gets a Transition Effect name based on the supplied TransitionEffectID.
|
| GetTransitionEffectIDFromName |
Gets the transition effect ID from the name provided.
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| GetUrlIDFromUrl |
Gets the URL ID from a specified URL
|
| GetWatermark |
Gets available Watermarks for requested map.
|
| GetWatermarkImages |
Gets all available Watermarks.
|
| GetWMSFromCapabilitiesOverlayIndex |
Gets the highest z index available for WMS From Capabilities Overlays for specified map.
|
| GetWMSOverlayIndex |
Gets the highest z index available for WMS Overlays for specified map.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| RemoveAdditionalWMSLayer |
Remove specified Additional WMS Layer from the system.
|
| RemoveBingLayer |
Removes a bing layer from the system.
|
| RemoveBookmark |
Remove a bookmark from the site.
|
| RemoveCRS |
Removes a CRS from the site.
|
| RemoveDatabaseConnection |
Removes a database connection from the database.
|
| RemoveGeognoSIS8AdditionalLayer |
Remove an additional GeognoSIS Layer.
|
| RemoveGeognoSIS8Layer |
Remove a GeognoSIS 8 Layer from the site.
|
| RemoveGeognoSISTileServiceLayer |
Removes a GegnoSIS Tile Service Layer from the system
|
| RemoveGeognoSISTileServiceLayerLookup |
Removes a GeognoSISTileService layer lookup
|
| RemoveGoogleLayer |
Removes a Google Layer from the system/
|
| RemoveLocalKnowledge |
Removes a local knowledge entry from the site.
|
| RemoveMap |
Remove a map from the site.
|
| RemoveNoticeBoard |
Removes a notice board from the system.
|
| RemoveNoticeBoardColumn |
Removes a column from the system.
|
| RemoveNoticeBoardLayer |
Removes a layer from the system.
|
| RemoveNoticeBoardNotice |
Removes a notice from the system.
|
| RemoveOSMLayer |
Remove an OSM layer from the site
|
| RemoveOSPlaces |
Removes a single OSPlaces search from the database.
|
| RemoveOSSearch |
Removes a single OSOpenNames searchc from the database.
|
| RemoveProxy |
Removes a proxy based on supplied ID.
|
| RemoveReportIt |
Removes a ReportIt record from the system.
|
| RemoveSingleSearch |
Removes a single singleSearch from the database.
|
| RemoveTemplate |
Removes a template from the site.
|
| RemoveTileCacheLayer |
Remove specified Tile Cache Layer from the system.
|
| RemoveWFSLayer |
Remove specified WFS Layer from the system.
|
| RemoveWMSFromCapabilitiesLayer |
Remove specified WMS From Capabilties Layer from the system.
|
| RemoveWMSLayer |
Remove specified WMS Layer from the system.
|
| RemoveWMTSLayer |
Remove specified WMTS Layer from the system.
|
| RemoveXYZLayer |
Remove a XYZ Layer from the specified map.
|
| ReplaceResolutions |
Replace resolutions for specified map.
|
| RequiresUpdate |
Determines if the current DB requires updating
|
| RunProcedure(String, String, IDataParameter, String) |
Runs a stored procedure, returning an SqlResultSet containing the result of the stored procedure.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, IDataParameter, Int32, String) |
Runs a stored procedure, returning an integer indicating the return value of the stored procedure.
Also returns the value of the RowsAffected aspect of the stored procedure that is returned by the
ExecuteNonQuery method.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, String) |
Runs a stored procedure, returning an SqlResultSet containing the result of the stored procedure.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, Int32, String) |
Runs a stored procedure, returning an integer indicating the return value of the stored procedure.
Also returns the value of the RowsAffected aspect of the stored procedure that is returned by the
ExecuteNonQuery method.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, String, String) |
Runs a stored procedure, returning a DataSet that contains the results of the stored procedure in
a named table.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, String, String) |
Runs a stored procedure, returning an ArrayList containing the specified fields from the result of the stored procedure.
N.B. This method has been retained for backward compatibility. It is recommended that a strongly typed generic list is used instead of an ArrayList.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, String, String) |
Runs a stored procedure, returning a DataSet that contains the results of the stored procedure in
a named table.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, String, String) |
Runs a stored procedure, returning an ArrayList containing the specified fields from the result of the stored procedure.
N.B. This method has been retained for backward compatibility. It is recommended that a strongly typed generic list is used instead of an ArrayList.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, DataSet, String, String) |
Takes an existing DataSet and fills the given table name with the results of the stored procedure.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, Int32, Int32, String) |
Returns a populated DataTable from the stored procedure provided.
(Inherited from DbDatabase.) |
| RunProcedure(String, String, IDataParameter, String, String, String) |
Runs a stored procedure, returning a DataView that contains the results of the stored procedure in
a named table within a DataSet.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, DataSet, String, String) |
Takes an existing DataSet and fills the given table name with the results of the stored procedure.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, Int32, Int32, String) |
Returns a populated DataTable from the stored procedure provided.
(Inherited from DbDatabase.) |
| RunProcedure(DbConnection, String, String, IDataParameter, String, String, String) |
Runs a stored procedure, returning a DataView that contains the results of the stored procedure in
a named table within a DataSet.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, String) |
Runs a query, returning an SqlResultSet containing the result of the query.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, IDataParameter, Int32, String) |
Runs a query, returning an integer indicating the return value of the stored procedure.
Also returns the value of the RowsAffected aspect of the stored procedure that is returned by the
ExecuteNonQuery method.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, String) |
Runs a query, returning an SqlResultSet containing the result of the query.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, DataTable, String) |
Takes an existing DataTable and fills it with the results of the query.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, Int32, String) |
Runs a query, returning an integer indicating the return value of the stored procedure.
Also returns the value of the RowsAffected aspect of the stored procedure that is returned by the
ExecuteNonQuery method.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, String, String) |
Runs a query, returning a DataSet that contains the results of the query in
a named table.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, String, String) |
Runs a stored procedure, returning an ArrayList containing the specified fields from the result of the query.
N.B. This method has been retained for backward compatibility. It is recommended that a strongly typed generic list is used instead of an ArrayList.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, DataTable, String) |
Takes an existing DataTable and fills it with the results of the query.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, String, String) |
Runs a query, returning a DataSet that contains the results of the query in
a named table.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, String, String) |
Runs a stored procedure, returning an ArrayList containing the specified fields from the result of the query.
N.B. This method has been retained for backward compatibility. It is recommended that a strongly typed generic list is used instead of an ArrayList.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, DataSet, String, String) |
Takes an existing DataSet and fills the given table name with the results of the query.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, Int32, Int32, String) |
Returns a populated DataTable from the query provided.
(Inherited from DbDatabase.) |
| RunQuery(String, String, IDataParameter, String, String, String) |
Runs a query, returning a DataView that contains the results of the query in
a named table within a DataSet.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, DataSet, String, String) |
Takes an existing DataSet and fills the given table name with the results of the query.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, Int32, Int32, String) |
Returns a populated DataTable from the query provided.
(Inherited from DbDatabase.) |
| RunQuery(DbConnection, String, String, IDataParameter, String, String, String) |
Runs a query, returning a DataView that contains the results of the query in
a named table within a DataSet.
(Inherited from DbDatabase.) |
| RunScalarQuery |
Runs a scalar query.
(Inherited from DbDatabase.) |
| SetOverlayIndex |
Sets the value of OverlayIndex column for a particular layer
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| TruncateString | (Inherited from DbDatabase.) |
| TypeToDbType |
Returns a DbType to go along with a parameter.
(Inherited from DbDatabase.) |
| Update |
Updates the database
|
| UpdateAppSettings |
Updates an app setting in the database.
|
| UpdateBookmark |
Update a bookmark in the site.
|
| UpdateFrontPageContent |
Updates the Front Page Content for the specified map.
|
| UpdateIcon |
Update details for icon.
|
| UpdateInitialLocation |
Update Initial Location for specified map.
|
| UpdateMapSettings |
Updates map settings for specified map.
|
| UpdateMaxExtent |
Update the map's maxium extent
|
| UpdateOSOpenNamesSearch |
Updates OS Searches to Search_OS_Places tables
|
| UpdateOSPlacesSearch |
Updates OS Searches to Search_OS_Places tables
|
| UpdateOverlayTypeStatus |
Updates the overlay type status
|
| UpdateStyle |
Update a style.
|
| UpdateWatermark |
Update details for watermark.
|
Fields| Name | Description | |
|---|---|---|
  | CURRENT_VERSION | |
| V8CURRENT_VERSION | |
| V9START_VERSION |
See Also