←Select platform

StorageSqlDbDataAccessAgent Class Members

Summary

The following tables list the members exposed by StorageSqlDbDataAccessAgent.

Public Constructors

Name Description
Public Constructor StorageDbDataAccessAgent7 Initializes a new instance of the StorageDbDataAccessAgent7 class. (Inherited from StorageDbDataAccessAgent7)
Public Constructor StorageSqlDbDataAccessAgent Initializes a new instance of the StorageSqlDbDataAccessAgent class with a connection string

Public Methods

Name Description
Public Method DeleteInstance Deletes the composite instances information that match the given query parameters, with an option to delete orphaned records. (Inherited from StorageDbDataAccessAgent7)
Public Method DeleteSeries Deletes the series records that match the given query parameters, with an option to delete orphaned records. (Inherited from StorageDbDataAccessAgent7)
Public Method DeleteStudy Delete the study records that match the given query parameters, with an option to delete orphaned records. (Inherited from StorageDbDataAccessAgent7)
Public Method EmptyTable Removes all records from the Patient, Study, Series, or Instance table. (Inherited from StorageDbDataAccessAgent7)
Public Method QueryPatients Queries for patient information with the specified matching parameters and ExtraQueryOptions. (Inherited from StorageDbDataAccessAgent7)
Public Method QuerySeries Queries for series information with the specified matching parameters and ExtraQueryOptions. (Inherited from StorageDbDataAccessAgent7)
Public Method QueryStudies Queries for study information with the specified matching parameters and ExtraQueryOptions. (Inherited from StorageDbDataAccessAgent7)
Public Method RemoveOrphanRecords Removes orphaned records from the Patient, Study, and Series database tables. (Inherited from StorageDbDataAccessAgent7)
Public Method StoreDicom Adds DICOM information into the storage source with an option to remove any generated orphaned records. (Inherited from StorageDbDataAccessAgent7)

Protected Methods

Name Description
Protected Method CreateDatabaseProvider Creates the database provider for connecting and working with DICOM Storage SQL Server database.
Protected Method GetCompositeInstanceQueryDataAdapterTables Returns the table names which should be used to update a System.Data.Common.DataAdapter.TableMappings when performing a query.
Protected Method GetHangingProtocolQueryDataAdapterTables Gets the list of Hanging Protocol Query Data Adapter Tables for this StorageSqlDbDataAccessAgent.
Protected Method InjectJoinForInstanceQuery Returns a string that joins user defined tables when performing an instance query
Protected Method InjectJoinForPatientQuery Returns a string that joins user defined tables when performing a patient query
Protected Method InjectJoinForSeriesQuery Returns a string that joins user defined tables when performing a series query.
Protected Method InjectJoinForStudyQuery Returns a string that joins user defined tables when performing a study query
Protected Method PrepareDeleteAllMetadataJsonCommand Initializes a System.Data.IDbCommand object that is used by the DeleteAllMetadataJson method.
Protected Method PrepareDeleteAllMetadataXmlCommand Initializes a System.Data.IDbCommand object that is used by the DeleteAllMetadataXml method.
Protected Method PrepareDeleteHangingProtocolCommand Initializes a System.Data.IDbCommand object to delete a hanging protocol.
Protected Method PrepareDeleteInstanceCommand Initializes a System.Data.IDbCommand object to delete composite instances using matching parameters.
Protected Method PrepareDeleteMetadataJsonCommand Initializes a System.Data.IDbCommand object that is used by the DeleteMetadataJson method.
Protected Method PrepareDeleteMetadataXmlCommand Initializes a System.Data.IDbCommand object that is used by the DeleteMetadataXml method.
Protected Method PrepareDeletePatientsCommand Initializes a System.Data.IDbCommand object to delete patients using matching parameters.
Protected Method PrepareDeletePatientsNoChildStudiesCommand(IDbCommand,Collection<CatalogElement[]>) Initializes a System.Data.IDbCommand object that is used by the DeleteStudy, DeleteSeries and DeleteInstance methods.
Protected Method PrepareDeleteSeriesCommand Initializes a System.Data.IDbCommand object to delete series using matching parameters.
Protected Method PrepareDeleteSeriesNoChildInstancesCommand(IDbCommand,Collection<CatalogElement[]>) Initializes a System.Data.IDbCommand object that is used by the DeleteInstance method.
Protected Method PrepareDeleteStudiesCommand Initializes a System.Data.IDbCommand object to delete studies using matching parameters.
Protected Method PrepareDeleteStudiesNoChildSeriesCommand(IDbCommand,Collection<CatalogElement[]>) Initializes a System.Data.IDbCommand object that is used by the DeleteSeries and DeleteInstance methods.
Protected Method PrepareEmptyTableCommand Initializes a System.Data.IDbCommand object to remove all records from the Patient, Study, Series, or Instance table.
Protected Method PrepareExistsHangingProtocolCommand Initializes a System.Data.IDbCommand object to check if a hanging protocol exists.
Protected Method PrepareExistsMetadataJsonCommand Initializes a System.Data.IDbCommand object that is used by the ExistsMetadataJson method.
Protected Method PrepareExistsMetadataXmlCommand Initializes a System.Data.IDbCommand object that is used by the ExistsMetadataXml method.
Protected Method PrepareGetCountMetadataJson Initializes a System.Data.IDbCommand object that is used by the GetCountMetadataJson method.
Protected Method PrepareGetCountMetadataXml Initializes a System.Data.IDbCommand object that is used by the GetCountMetadataXml method.
Protected Method PrepareHangingProtocolQueryCountCommand Initializes a System.Data.IDbCommand object to query for hanging protocol count using matching parameters.
Protected Method PrepareInsertCodeSequenceCommand Initializes a System.Data.IDbCommand object to insert a code sequence.
Protected Method PrepareInsertHangingProtocolCommand Initializes a System.Data.Common.DbCommand object to insert a hanging protocol row into the database table.
Protected Method PrepareInsertHangingProtocolDefinitonSequenceCommand Initializes a System.Data.Common.DbCommand object to insert a hanging protocol definition sequence row into the database table.
Protected Method PrepareInsertMetadataJsonCommand Initializes a System.Data.IDbCommand object that is used by the StoreMetadataJson method.
Protected Method PrepareInsertMetadataXmlCommand Initializes a System.Data.IDbCommand object that is used by the StoreMetadataXml method.
Protected Method PrepareInstancePageQueryCommand Initializes a System.Data.IDbCommand object to query for Composite Instance information using matching parameters for pagination.
Protected Method PrepareInstanceQueryCommand Initializes a System.Data.IDbCommand object to query for Composite Instance information using matching parameters.
Protected Method PrepareInstanceQueryCountCommand Initializes a System.Data.IDbCommand object to query for composite instances count using matching parameters.
Protected Method PrepareIsInstanceExistsCommand Initializes a System.Data.IDbCommand object to check whether a DICOM Instance information exists.
Protected Method PrepareIsPatientExistsCommand Initializes a System.Data.IDbCommand object to check whether a patient information exists.
Protected Method PrepareIsSeriesExistsCommand Initializes a System.Data.IDbCommand object to check whether a series information exists.
Protected Method PrepareIsStudyExistsCommand Initializes a System.Data.IDbCommand object to check whether a study information exists.
Protected Method PreparePatientsPageQueryCommand Initializes a System.Data.IDbCommand object to query for patients page using matching parameters.
Protected Method PreparePatientsQueryCommand Initializes a System.Data.IDbCommand object to query for patient information using matching parameters.
Protected Method PreparePatientsQueryCountCommand Initializes a System.Data.IDbCommand object to query for patients count using matching parameters.
Protected Method PrepareQueryHangingProtocolCommand Initializes a System.Data.IDbCommand object to query for hanging protocol information using matching parameters.
Protected Method PrepareQueryMetadataJson Initializes a System.Data.IDbCommand object that is used by the GenerateMetadataJson method.
Protected Method PrepareQueryMetadataXml Initializes a System.Data.IDbCommand object that is used by the GenerateMetadataXml method.
Protected Method PrepareSeriesPageQueryCommand Initializes a System.Data.IDbCommand object to query for series page using matching parameters.
Protected Method PrepareSeriesQueryCommand Initializes a System.Data.IDbCommand object to query for series information using matching parameters.
Protected Method PrepareSeriesQueryCountCommand Initializes a System.Data.IDbCommand object to query for series count using matching parameters.
Protected Method PrepareStudiesPageQueryCommand Initializes a System.Data.IDbCommand object to query for studies page using matching parameters.
Protected Method PrepareStudiesQueryCommand Initializes a System.Data.IDbCommand object to query for studies information using matching parameters.
Protected Method PrepareStudiesQueryCountCommand Initializes a System.Data.IDbCommand object to query for studies count using matching parameters.
Protected Method PrepareUpdateMetadataJsonCommand Initializes a System.Data.IDbCommand object that is used by the StoreMetadataJson method.
Protected Method PrepareUpdateMetadataXmlCommand Initializes a System.Data.IDbCommand object that is used by the StoreMetadataXml method.
Protected Method UpdateTable Update a specific table in a CompositeInstanceDataSet by adding, deleting or modifying information.

Public Properties

Name Description
Public Property ConnectionString Gets or sets the connection string for the DICOM Storage database.
Public Property DiagnosticLevel Gets or sets a value indicating the diagnostic level. (Inherited from StorageDbDataAccessAgent7)
Public Property Timeout Gets or sets the wait time (in seconds) before terminating the attempt to execute the command and generating an error. (Inherited from StorageDbDataAccessAgent7)

See Also

StorageSqlDbDataAccessAgent Class

Leadtools.Medical.Storage.DataAccessLayer Namespace

Help Version 22.0.2023.2.5
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Medical.Storage.DataAccessLayer Assembly
Introduction
Getting Started
Namespaces
Leadtools.Medical.Storage.DataAccessLayer Namespace
Leadtools.Medical.Storage.DataAccessLayer.Configuration Namespace
Leadtools.Medical.Storage.DataAccessLayer.Interface Namespace
Leadtools.Medical.Storage.DataAccessLayer.MatchingParameters Namespace
Assemblies
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.