LAUREL BRIDGE

Database Class

DICOM Connectivity Framework V3.4
Performs all the communication to/from the database.
Inheritance Hierarchy

SystemObject
  LaurelBridge.DCF.Examples.SampleVNADatabase

Namespace:  LaurelBridge.DCF.Examples.SampleVNA
Assembly:  SampleVNA (in SampleVNA.exe) Version: DCF34 r11232 DCF_3_4_20
Syntax

C#
public class Database

The Database type exposes the following members.

Constructors

  NameDescription
Public methodDatabase
Initializes a new instance of the Database class
Top
Properties

  NameDescription
Public propertyStatic memberConnectionDictionary
A dictionary of AssociationAcceptor ids to SqlCeConnection objects.
Top
Methods

  NameDescription
Public methodStatic memberContainsImage
Determines if an image already exists in the database for the specified ImageRecord.
Public methodStatic memberContainsPatient
Determines if a patient already exists in the database for the specified PatientRecord.
Public methodStatic memberContainsSeries
Determines if a series already exists in the database for the specified SeriesRecord.
Public methodStatic memberContainsStudy
Determines if a study already exists in the database for the specified StudyRecord.
Public methodStatic memberGetMatchingImageRecords(SqlCeConnection, ImageRecord)
Gets all of the ImageRecords in the database that match the information specified by the query object.
Public methodStatic memberGetMatchingImageRecords(SqlCeConnection, PatientRecord)
Gets the matching ImageRecord objects for the specified PatientRecord.
Public methodStatic memberGetMatchingImageRecords(SqlCeConnection, SeriesRecord)
Gets the matching ImageRecord objects for the specified SeriesRecord.
Public methodStatic memberGetMatchingImageRecords(SqlCeConnection, StudyRecord)
Gets the matching ImageRecord objects for the specified StudyRecord.
Public methodStatic memberGetMatchingPatientRecords
Gets all of the PatientRecords in the database that match the information specified by the query object.
Public methodStatic memberGetMatchingSeriesRecords
Gets all of the SeriesRecords in the database that match the information specified by the query object.
Public methodStatic memberGetMatchingStudyRecords
Gets all of the StudyRecords in the database that match the information specified by the query object.
Public methodStatic memberGetMoveDestination
Gets the RemoteDevice configured for the specified moveAE title.
Public methodStatic memberGetRemoteDevices
Gets the list (if any) of remote devices that match the info specified by the AssociationAcceptor.
Public methodStatic memberInsertImage
Inserts the specified ImageRecord into the database.
Public methodStatic memberInsertPatient
Inserts the specified PatientRecord into the database.
Public methodStatic memberInsertSeries
Inserts the specified SeriesRecord into the database.
Public methodStatic memberInsertStudy
Inserts the specified StudyRecord into the database.
Top
Fields

  NameDescription
Public fieldStatic memberConnectionString
The connection string for the database.
Top
Remarks

Some of the tables in the database should be populated with information prior to SCUs issueing 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 106)

See Also

Reference