←Select platform
In This Topic ▼

StorageSqlDbDataAccessAgent Class Members

Summary

The following tables list the members exposed by StorageSqlDbDataAccessAgent.

Public Constructors

Name Description
Public Constructor StorageSqlDbDataAccessAgent Initializes a new instance of the StorageSqlDbDataAccessAgent class with a connection string

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 Initializes a System.Data.IDbCommand object to delete orphan studies that does not have child series information.
Protected Method PrepareDeleteSeriesCommand Initializes a System.Data.IDbCommand object to delete series using matching parameters.
Protected Method PrepareDeleteSeriesNoChildInstancesCommand Initializes a System.Data.IDbCommand object to delete orphan patients that does not have child studies information.
Protected Method PrepareDeleteStudiesCommand Initializes a System.Data.IDbCommand object to delete studies using matching parameters.
Protected Method PrepareDeleteStudiesNoChildSeriesCommand Initializes a System.Data.IDbCommand object to delete orphan series that does not have child composite instances information.
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.

See Also

Reference

StorageSqlDbDataAccessAgent Class

Leadtools.Medical.Storage.DataAccessLayer Namespace

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

Leadtools.Medical.Storage.DataAccessLayer Assembly

Products | Support | Contact Us | Intellectual Property Notices
© 1991-2021 LEAD Technologies, Inc. All Rights Reserved.