In This Topic ▼

GenerateWhereStatement Method

Summary

Generates a SQL WHERE statement using the given matching parameters.

Syntax

C++

public static string GenerateWhereStatement( 
   Collection<CatalogElement[]> matchingParams 
)

  
Public Shared Function GenerateWhereStatement( _ 
   ByVal matchingParams As Collection(Of CatalogElement()) _ 
) As String

public: 
static String^ GenerateWhereStatement(  
   Collection<array<CatalogElement^>>^ matchingParams 
)

Parameters

matchingParams
A collection of Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement array to generate the SQL WHERE statement from.

Return Value

A SQL WHERE statement using the given matching parameters.

Remarks

The returned SQL statement is not guaranteed to work with all database engines. However, the statement can be used with Microsoft SQL Server engines.

The method works by combining all of the Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement in each array with an AND operator and inserting an OR operator between each Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement array.

The method will use the Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement.EntityName property as the SQL table name and the Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement.ElementName property as the SQL column name for the SQL statement.

For date-time matching, this method can handle the System.DateTime, Leadtools.Dicom.DicomDateRangeValue, Leadtools.Dicom.DicomTimeRangeValue and Leadtools.Dicom.Common.DataTypes.DateRange data types.

Any other value will be converted to a string where wild card/single character matching can be performed using the MatchAllCharacters and MatchOneCharacter methods.

If the string value contains the MatchingValueSeparator value, the values will be separated with an OR operator.

Override the default using the WhereStatementGenerator property.

Requirements

Target Platforms

Reference

SqlProviderUtilities Class

SqlProviderUtilities Members

Download our FREE evaluation

Help Version 21.0.2021.6.30

Leadtools.Medical.DataAccessLayer Assembly

Introduction

Getting Started

Namespaces

Leadtools.Medical.DataAccessLayer Namespace

Leadtools.Medical.DataAccessLayer.Catalog Namespace

Leadtools.Medical.DataAccessLayer.Configuration Namespace

Assemblies