StorageSqlDbDataAccessAgent Class Members

Summary

The following tables list the members exposed by StorageSqlDbDataAccessAgent.

Public Constructors

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

Protected Methods

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