Vuresoft.Dicom.Sqlite 0.2.0

Vuresoft.Dicom.Sqlite

** BETA VERSION **

A .NET library for storing DICOM medical images in SQLite databases. Each DICOM study is stored in its own SQLite database file, containing all instances with their complete image data.

Features

• Store complete DICOM studies in single SQLite database files
• One database per study for easy management and portability
• Retrieve DICOM data by Study, Series, and Instance UIDs
• Bulk import from directories or file lists
• Thread-safe concurrent access with built-in locking

Installation

Add reference to Vuresoft.Dicom.Sqlite project or NuGet package (when available).

Basic Usage

Create a database from a directory of DICOM files

using Vuresoft.Dicom.Sqlite;

// Create a new database from a folder containing DICOM files
var db = await SqliteDicomStudyDb.CreateFromDirectoryAsync(
    sourceDirectory: @"C:\DicomFiles\Study123",
    databasePath: @"C:\Studies\study123.db"
);

Add DICOM files to an existing database

using var db = new SqliteDicomStudyDb(@"C:\Studies\study123.db");

// Add a single file
await db.AddInstanceFromFileAsync(@"C:\DicomFiles\image.dcm");

// Import multiple files
var files = new[] { "file1.dcm", "file2.dcm", "file3.dcm" };
await db.ImportFilesAsync(files);

// Import entire directory
await db.ImportDirectoryAsync(@"C:\DicomFiles\Study123");

Retrieve DICOM data

using var db = new SqliteDicomStudyDb(@"C:\Studies\study123.db");

// Get a single instance as DicomDataset
var dataset = await db.GetInstanceAsync(studyUid, seriesUid, sopUid);

// Get raw DICOM bytes
var bytes = await db.GetInstanceBytesAsync(studyUid, seriesUid, sopUid);

// Get all instances in a series
var seriesDatasets = await db.GetSeriesAsync(studyUid, seriesUid);

// Get all instances in a study
var studyBytes = await db.GetStudyBytesAsync(studyUid);

Database Structure

Each SQLite database contains:

• Study table - Study Instance UID
• Series table - Series Instance UIDs linked to studies
• Instance table - SOP Instance UIDs with complete DICOM file data stored as BLOB

Dependencies

• fo-dicom - DICOM file parsing
• Microsoft.EntityFrameworkCore.Sqlite - Database access
• .NET 10.0 or later

Thread Safety

The library includes built-in thread safety with per-study locking mechanisms to handle concurrent read/write operations safely.