Sample Database for the LEAD Storage Server (original) (raw)

Step 1: Configure the LEAD Storage Server with the Shipping Database Schema

Step 2: Create the Custom Storage Data Access Layer, and Configuration Assemblies

Step 3: Create the Sample Database

This tutorial uses Microsoft SQL Server 2008 and SQL Server Management Studio. You can also use SQL Compact Edition, which is installed by default when you install Visual Studio. If you use SQL Compact Edition, you can download SQL Server Management Studio Express (a free download from Microsoft).

Script to generate the tutorial database for SQL Server 2008

USE [master] GO /****** Object: Database [MyDicomDb] Script Date: 07/15/2013 13:02:13 ******/ CREATE DATABASE [MyDicomDb] GO ALTER DATABASE [MyDicomDb] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [MyDicomDb].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [MyDicomDb] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_NULLS OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_PADDING OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_WARNINGS OFF GO ALTER DATABASE [MyDicomDb] SET ARITHABORT OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_CLOSE OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [MyDicomDb] SET AUTO_SHRINK OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [MyDicomDb] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [MyDicomDb] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [MyDicomDb] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [MyDicomDb] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [MyDicomDb] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [MyDicomDb] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [MyDicomDb] SET DISABLE_BROKER GO ALTER DATABASE [MyDicomDb] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [MyDicomDb] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [MyDicomDb] SET TRUSTWORTHY OFF GO ALTER DATABASE [MyDicomDb] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [MyDicomDb] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [MyDicomDb] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [MyDicomDb] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [MyDicomDb] SET READ_WRITE GO ALTER DATABASE [MyDicomDb] SET RECOVERY FULL GO ALTER DATABASE [MyDicomDb] SET MULTI_USER GO ALTER DATABASE [MyDicomDb] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [MyDicomDb] SET DB_CHAINING OFF GO EXEC sys.sp_db_vardecimal_storage_format N'MyDicomDb', N'ON' GO USE [MyDicomDb] GO /****** Object: Table [dbo].[MyPatientTable] Script Date: 07/01/2013 17:44:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyPatientTable]( [PatientId] [int] IDENTITY(1,1) NOT NULL, [PatientIdentification] [nvarchar](70) NOT NULL, [PatientName] [nvarchar](max) NOT NULL, [PatientBirthday] [date] NULL, [PatientSex] [nvarchar](50) NULL, [PatientComments] [nvarchar](200) NULL, CONSTRAINT [PK_Patient] PRIMARY KEY CLUSTERED ( [PatientId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_PatientIdentification] UNIQUE NONCLUSTERED ( [PatientIdentification] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MyStudyTable] Script Date: 07/01/2013 17:44:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyStudyTable]( [StudyId] [int] IDENTITY(1,1) NOT NULL, [StudyPatientId] [int] NOT NULL, [StudyStudyInstanceUID] [nvarchar](64) NOT NULL, [StudyStudyDate] [date] NULL, [StudyAccessionNumber] [nvarchar](64) NULL, [StudyStudyDescription] [nvarchar](256) NULL, [StudyReferringPhysiciansName] [nvarchar](50) NULL, [StudyStudyId] [nvarchar](16) NULL, CONSTRAINT [PK_Study] PRIMARY KEY CLUSTERED ( [StudyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_StudyStudyInstanceUID] UNIQUE NONCLUSTERED ( [StudyStudyInstanceUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MySeriesTable] Script Date: 07/01/2013 17:44:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MySeriesTable]( [SeriesId] [int] IDENTITY(1,1) NOT NULL, [SeriesStudyId] [int] NOT NULL, [SeriesSeriesInstanceUID] [nvarchar](64) NOT NULL, [SeriesBodyPartExamined] [nvarchar](16) NULL, [SeriesSeriesNumber] [int] NULL, [SeriesSeriesDescription] [nvarchar](300) NULL, [SeriesSeriesDate] [date] NULL, [SeriesModality] [nvarchar](50) NULL, CONSTRAINT [PK_Series] PRIMARY KEY CLUSTERED ( [SeriesId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_SerieSeriesInstanceUID] UNIQUE NONCLUSTERED ( [SeriesSeriesInstanceUID] ASC, [SeriesStudyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MyInstanceTable] Script Date: 07/01/2013 17:44:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyInstanceTable]( [ImageId] [bigint] IDENTITY(1,1) NOT NULL, [ImageSeriesId] [int] NOT NULL, [SOPInstanceUID] [nvarchar](64) NOT NULL, [ImageImageNumber] [int] NOT NULL, [ImageLastStoreDate] [date] NULL, [ImageFilename] [nvarchar](400) NOT NULL, [ImageUniqueSOPClassUID] [nvarchar](64) NULL, [ImageRows] [bigint] NULL, [ImageColumns] [bigint] NULL, [ImageBitsAllocated] [bigint] NULL, CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ImageId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Image_SOPInstanceUID] UNIQUE NONCLUSTERED ( [SOPInstanceUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: ForeignKey [FK_DImage_Series] Script Date: 07/01/2013 17:44:15 ******/ ALTER TABLE [dbo].[MyInstanceTable] WITH CHECK ADD CONSTRAINT [FK_DImage_Series] FOREIGN KEY([ImageSeriesId]) REFERENCES [dbo].[MySeriesTable] ([SeriesId]) ON DELETE CASCADE GO ALTER TABLE [dbo].[MyInstanceTable] CHECK CONSTRAINT [FK_DImage_Series] GO /****** Object: ForeignKey [FK_Series_Study] Script Date: 07/01/2013 17:44:15 ******/ ALTER TABLE [dbo].[MySeriesTable] WITH CHECK ADD CONSTRAINT [FK_Series_Study] FOREIGN KEY([SeriesStudyId]) REFERENCES [dbo].[MyStudyTable] ([StudyId]) GO ALTER TABLE [dbo].[MySeriesTable] CHECK CONSTRAINT [FK_Series_Study] GO /****** Object: ForeignKey [FK_Study_Patient] Script Date: 07/01/2013 17:44:15 ******/ ALTER TABLE [dbo].[MyStudyTable] WITH CHECK ADD CONSTRAINT [FK_Study_Patient] FOREIGN KEY([StudyPatientId]) REFERENCES [dbo].[MyPatientTable] ([PatientId]) GO ALTER TABLE [dbo].[MyStudyTable] CHECK CONSTRAINT [FK_Study_Patient] GO

Note:

For earlier version of SQL Server (i.e. SQL Server 2005), there is no support for the data type SqlDbType.Date.

If you are using SQL Server 2005, you can use the following script to generate the database, which instead uses the data type SqlDbType.DateTime.

Script to generate the tutorial database for SQL Server 2005

USE [master] GO /****** Object: Database [MyDicomDb] Script Date: 08/12/2013 10:39:18 ******/ CREATE DATABASE [MyDicomDb] GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [MyDicomDb].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [MyDicomDb] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_NULLS OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_PADDING OFF GO ALTER DATABASE [MyDicomDb] SET ANSI_WARNINGS OFF GO ALTER DATABASE [MyDicomDb] SET ARITHABORT OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_CLOSE OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [MyDicomDb] SET AUTO_SHRINK OFF GO ALTER DATABASE [MyDicomDb] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [MyDicomDb] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [MyDicomDb] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [MyDicomDb] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [MyDicomDb] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [MyDicomDb] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [MyDicomDb] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [MyDicomDb] SET DISABLE_BROKER GO ALTER DATABASE [MyDicomDb] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [MyDicomDb] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [MyDicomDb] SET TRUSTWORTHY OFF GO ALTER DATABASE [MyDicomDb] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [MyDicomDb] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [MyDicomDb] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [MyDicomDb] SET READ_WRITE GO ALTER DATABASE [MyDicomDb] SET RECOVERY FULL GO ALTER DATABASE [MyDicomDb] SET MULTI_USER GO ALTER DATABASE [MyDicomDb] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [MyDicomDb] SET DB_CHAINING OFF GO USE [MyDicomDb] GO /****** Object: Table [dbo].[MyPatientTable] Script Date: 08/12/2013 10:39:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyPatientTable]( [PatientId] [int] IDENTITY(1,1) NOT NULL, [PatientIdentification] [nvarchar](70) NOT NULL, [PatientName] [nvarchar](max) NOT NULL, [PatientBirthday] [datetime] NULL, [PatientSex] [nvarchar](50) NULL, [PatientComments] [nvarchar](200) NULL, CONSTRAINT [PK_Patient] PRIMARY KEY CLUSTERED ( [PatientId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_PatientIdentification] UNIQUE NONCLUSTERED ( [PatientIdentification] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MyStudyTable] Script Date: 08/12/2013 10:39:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyStudyTable]( [StudyId] [int] IDENTITY(1,1) NOT NULL, [StudyPatientId] [int] NOT NULL, [StudyStudyInstanceUID] [nvarchar](64) NOT NULL, [StudyStudyDate] [datetime] NULL, [StudyAccessionNumber] [nvarchar](64) NULL, [StudyStudyDescription] [nvarchar](256) NULL, [StudyReferringPhysiciansName] [nvarchar](50) NULL, [StudyStudyId] [nvarchar](16) NULL, CONSTRAINT [PK_Study] PRIMARY KEY CLUSTERED ( [StudyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_StudyStudyInstanceUID] UNIQUE NONCLUSTERED ( [StudyStudyInstanceUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MySeriesTable] Script Date: 08/12/2013 10:39:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MySeriesTable]( [SeriesId] [int] IDENTITY(1,1) NOT NULL, [SeriesStudyId] [int] NOT NULL, [SeriesSeriesInstanceUID] [nvarchar](64) NOT NULL, [SeriesBodyPartExamined] [nvarchar](16) NULL, [SeriesSeriesNumber] [int] NULL, [SeriesSeriesDescription] [nvarchar](300) NULL, [SeriesSeriesDate] [datetime] NULL, [SeriesModality] [nvarchar](50) NULL, CONSTRAINT [PK_Series] PRIMARY KEY CLUSTERED ( [SeriesId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [uc_SerieSeriesInstanceUID] UNIQUE NONCLUSTERED ( [SeriesSeriesInstanceUID] ASC, [SeriesStudyId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[MyInstanceTable] Script Date: 08/12/2013 10:39:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MyInstanceTable]( [ImageId] [bigint] IDENTITY(1,1) NOT NULL, [ImageSeriesId] [int] NOT NULL, [SOPInstanceUID] [nvarchar](64) NOT NULL, [ImageImageNumber] [int] NOT NULL, [ImageLastStoreDate] [datetime] NULL, [ImageFilename] [nvarchar](400) NOT NULL, [ImageUniqueSOPClassUID] [nvarchar](64) NULL, [ImageRows] [bigint] NULL, [ImageColumns] [bigint] NULL, [ImageBitsAllocated] [bigint] NULL, CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED ( [ImageId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Image_SOPInstanceUID] UNIQUE NONCLUSTERED ( [SOPInstanceUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: ForeignKey [FK_Study_Patient] Script Date: 08/12/2013 10:39:19 ******/ ALTER TABLE [dbo].[MyStudyTable] WITH CHECK ADD CONSTRAINT [FK_Study_Patient] FOREIGN KEY([StudyPatientId]) REFERENCES [dbo].[MyPatientTable] ([PatientId]) GO ALTER TABLE [dbo].[MyStudyTable] CHECK CONSTRAINT [FK_Study_Patient] GO /****** Object: ForeignKey [FK_Series_Study] Script Date: 08/12/2013 10:39:19 ******/ ALTER TABLE [dbo].[MySeriesTable] WITH CHECK ADD CONSTRAINT [FK_Series_Study] FOREIGN KEY([SeriesStudyId]) REFERENCES [dbo].[MyStudyTable] ([StudyId]) GO ALTER TABLE [dbo].[MySeriesTable] CHECK CONSTRAINT [FK_Series_Study] GO /****** Object: ForeignKey [FK_DImage_Series] Script Date: 08/12/2013 10:39:19 ******/ ALTER TABLE [dbo].[MyInstanceTable] WITH CHECK ADD CONSTRAINT [FK_DImage_Series] FOREIGN KEY([ImageSeriesId]) REFERENCES [dbo].[MySeriesTable] ([SeriesId]) ON DELETE CASCADE GO ALTER TABLE [dbo].[MyInstanceTable] CHECK CONSTRAINT [FK_DImage_Series] GO

Step 4: Modify GlobalPacs.config to use the New Database

<add productName="Workstation" serviceName="L21_WS_SERVER32"
connectionName="MedicalWorkstation21_32" />
</storageDataAccessConfiguration175>

<myStorageDataAccessConfiguration175 connectionName="MyDicomDb">
<add productName="StorageServer" serviceName=" L21_PACS_SCP32" connectionName="MyDicomDb" />
</myStorageDataAccessConfiguration175>

Step 5: Copy the Following Files to {LEAD Installation BIN}

Step 6: Rebuild the StorageServerManagerDemo_Original.exe with Modifications

storageAgent = DataAccessFactory.GetInstance ( new MyStorageDataAccessConfigurationView(configuration, DicomDemoSettingsManager.ProductNameStorageServer, null)).CreateDataAccessAgent <IStorageDataAccessAgent> ( ) ;  

MyPatient patient = new MyPatient();
MyStudy study = new MyStudy();
MySeries series = new MySeries();

matchingList.Add(patient);
matchingList.Add(study);
matchingList.Add(series);

matchingCollection.Add(matchingList);
study.StudyAccessionNumber = q.AccessionNumber;
patient.PatientIdentification = q.PatientId;

if (!string.IsNullOrEmpty(q.PatientName.FamilyName))
patient.PatientName = q.PatientName.FamilyName.TrimEnd('*') + "*";

if (!string.IsNullOrEmpty(q.PatientName.GivenName))
patient.PatientName = q.PatientName.GivenName.TrimEnd('*') + "*";

if (!string.IsNullOrEmpty(q.Modalities))
series.SeriesModality = q.Modalities.Replace(",", "\\"); ;

if (!string.IsNullOrEmpty(q.SeriesDescription))
series.SeriesSeriesDescription = q.SeriesDescription.TrimEnd('*') + "*";

if (!string.IsNullOrEmpty(q.ReferringPhysiciansName.FamilyName))
study.StudyReferringPhysiciansName = q.ReferringPhysiciansName.FamilyName.TrimEnd('*') + "*"; ;

if (!string.IsNullOrEmpty(q.ReferringPhysiciansName.GivenName))
study.StudyReferringPhysiciansName = q.ReferringPhysiciansName.GivenName.TrimEnd('*') + "*"; ;

if (q.StudyFromChecked || q.StudyToChecked)
{
DateRange studyDateRange = new DateRange();

if (q.StudyFromChecked)
{
studyDateRange.StartDate = q.StudyFromDate;
}

if (q.StudyToChecked)
{
studyDateRange.EndDate = q.StudyToDate;
}

study.StudyStudyDate = studyDateRange;
}

if (q.StorageDateChecked)
{
MyInstance instance = new MyInstance();
DateRange dateRange = new DateRange();
DateRangeFilter StorageDateRangeFilter = q.StorageDateRange;
string startDate = StorageDateRangeFilter.DateRangeFrom;
string endDate = StorageDateRangeFilter.DateRangeTo;

if (StorageDateRangeFilter.SelectedDateFilter == DateRangeFilter.RangeFilterType.DateRange)
{
if (!string.IsNullOrEmpty(startDate))
{
dateRange.StartDate = DateTime.Parse(startDate);
}

if (!string.IsNullOrEmpty(endDate))
{
dateRange.EndDate = DateTime.Parse(endDate);
}
}
else if (StorageDateRangeFilter.SelectedDateFilter == DateRangeFilter.RangeFilterType.Months)
{
DateTime lastMonthsDate = DateTime.Now.SubtractMonths(Convert.ToInt32(StorageDateRangeFilter.LastMonths));

dateRange.StartDate = lastMonthsDate;
dateRange.EndDate = DateTime.Now;
}
else
{
TimeSpan subtractionDays = new TimeSpan(Convert.ToInt32(StorageDateRangeFilter.LastDays),
DateTime.Now.Hour,
DateTime.Now.Minute,
DateTime.Now.Second,
DateTime.Now.Millisecond);

dateRange.StartDate = DateTime.Now.Subtract(subtractionDays);
dateRange.EndDate = DateTime.Now;
}

instance.ImageLastStoreDate = dateRange;
matchingList.Add(instance);
}

study.StudyStudyId = q.StudyId;
}
catch (Exception exception)
{
throw exception;
}
finally
{
// do nothing ;
}
}

Step 7: Modify Application Configuration Files to use the Storage Catalog and DataSet Schema

</sectionGroup>
</configSections>
<leadLogging>
<channels>
<channel name="DataAccessLoggingChannel" type="Leadtools.Medical.Logging.DataAccessLayer.DataAccessLoggingChannel, Leadtools.Medical.Logging.DataAccessLayer" />
</channels>
</leadLogging>
<xmlStorageCatalogSettings catalogPath="C:\LEADTOOLS22\Bin\Dotnet4\Win32\MyCatalog.xml"/>
<runtime>
<generatePublisherEvidence enabled="false"/>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845DCD8080CC91" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-3.5.1.0" newVersion="3.5.1.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Practices.ObjectBuilder2" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-2.2.0.0" newVersion="2.2.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Practices.Unity" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-1.2.0.0" newVersion="1.2.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
<appSettings>
<add key="LicenseFile" value=""/>
<add key="DeveloperKey" value=""/>
<add key="DataSetSchema" value=" C:\LEADTOOLS22\Bin\Dotnet4\Win32\MyDataSet.xsd"/>
</appSettings>
</configuration>

<dependentAssembly>
<assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845DCD8080CC91" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-3.5.1.0" newVersion="3.5.1.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Practices.ObjectBuilder2" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-2.2.0.0" newVersion="2.2.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Practices.Unity" publicKeyToken="31BF3856AD364E35" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-1.2.0.0" newVersion="1.2.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>

<appSettings>
<add key="DataSetSchema" value=" C:\LEADTOOLS22\Bin\Dotnet4\Win32\MyDataSet.xsd"/>
</appSettings>
</configuration>

Step 8: Configure the Storage Server Manager to use MyQueryIOD.xml

Step 9: (Optional) Configure the Forward Feature

Script to create the Forward table

USE [MyDicomDb] GO /****** Object: Table [dbo].[Forward] Script Date: 09/04/2013 15:55:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Forward]( [SOPInstanceUID] [nvarchar](64) NOT NULL, [ForwardDate] [datetime] NULL, [ExpireDate] [datetime] NULL, CONSTRAINT [PK_Forward] PRIMARY KEY CLUSTERED ( [SOPInstanceUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Forward] WITH CHECK ADD CONSTRAINT [FK_Forward_Instance] FOREIGN KEY([SOPInstanceUID]) REFERENCES [dbo].[MyInstanceTable] ([SOPInstanceUID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[Forward] CHECK CONSTRAINT [FK_Forward_Instance] GO

Step 10: Verify that the Storage Server Manager is Using the Custom Database