Database Class


Database Class	DICOM Connectivity Framework V3.4

Performs all the communication to/from the database.

Inheritance Hierarchy

SystemObject
LaurelBridge.DCFExamples.SampleVNADatabase

Namespace: LaurelBridge.DCFExamples.SampleVNA
Assembly: SampleVNA (in SampleVNA.exe) Version: DCF34 r13043 DCF_3_4_56_20220408 NetFramework

Syntax

Copy

public class Database

The Database type exposes the following members.

Constructors

	Name	Description
	Database	Initializes a new instance of the Database class

Top

Properties

	Name	Description
	ConnectionDictionary	A dictionary of AssociationAcceptor ids to SqlCeConnection objects.

Top

Methods

	Name	Description
	ContainsImage	Determines if an image already exists in the database for the specified ImageRecord.
	ContainsPatient	Determines if a patient already exists in the database for the specified PatientRecord.
	ContainsSeries	Determines if a series already exists in the database for the specified SeriesRecord.
	ContainsStudy	Determines if a study already exists in the database for the specified StudyRecord.
	GetMatchingImageRecords(SqlCeConnection, ImageRecord)	Gets all of the ImageRecords in the database that match the information specified by the query object.
	GetMatchingImageRecords(SqlCeConnection, PatientRecord)	Gets the matching ImageRecord objects for the specified PatientRecord.
	GetMatchingImageRecords(SqlCeConnection, SeriesRecord)	Gets the matching ImageRecord objects for the specified SeriesRecord.
	GetMatchingImageRecords(SqlCeConnection, StudyRecord)	Gets the matching ImageRecord objects for the specified StudyRecord.
	GetMatchingPatientRecords	Gets all of the PatientRecords in the database that match the information specified by the query object.
	GetMatchingSeriesRecords	Gets all of the SeriesRecords in the database that match the information specified by the query object.
	GetMatchingStudyRecords	Gets all of the StudyRecords in the database that match the information specified by the query object.
	GetMoveDestination	Gets the RemoteDevice configured for the specified moveAE title.
	GetRemoteDevices	Gets the list (if any) of remote devices that match the info specified by the AssociationAcceptor.
	InsertImage	Inserts the specified ImageRecord into the database.
	InsertPatient	Inserts the specified PatientRecord into the database.
	InsertSeries	Inserts the specified SeriesRecord into the database.
	InsertStudy	Inserts the specified StudyRecord into the database.

Top

Fields

	Name	Description
	ConnectionString	The connection string for the database.

Top

Remarks

Some of the tables in the database should be populated with information prior to SCUs issuing requests to the SCP. For example, association requests from SCUs will be rejected unless a match is found in the remote_device table. Likewise, a C-Move request will ultimately fail if no move destination is found in the move_destination table. Therefore, the user of this example can/should populate those tables with information. See https://technet.microsoft.com/en-us/library/gg592948(v=sql.110).aspx for how to connect to a SQL CE 4.0 database using Visual Studio. Once connected, right-clicking on the various tables and selecting "Show Table Data" will display the current contents of the selected table, at which point the user can modify/add/remove rows.

Step by Step For Beginners/Testers: The compatible sqlite plugin for VS can be obtained from: https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox Download and install. In VS2017->Examples, View->Server Explorer, Right click Data Connections->Add Connection In this Dialog the full path to SampleVNA.sdf must be specified and the password (12345) Ensure Test Connection works (Button) Launch SampleVNA example Run Power Tools Study Generator (on same localhost) to verify operation (change port to 10106)

Reference

LaurelBridge.DCFExamples.SampleVNA Namespace