in src/Microsoft.Health.Dicom.SqlServer/Features/Query/SqlQueryGenerator.cs [473:511]
private static string GetTableAlias(DicomTagSqlEntry sqlEntry, int? extendedQueryTagKey)
{
string ret = null;
switch (sqlEntry.SqlTableType)
{
case SqlTableType.InstanceTable:
ret = InstanceTableAlias;
break;
case SqlTableType.StudyTable:
ret = StudyTableAlias;
break;
case SqlTableType.SeriesTable:
ret = SeriesTableAlias;
break;
case SqlTableType.ExtendedQueryTagLongTable:
ret = ExtendedQueryTagLongTableAlias;
break;
case SqlTableType.ExtendedQueryTagDateTimeTable:
ret = ExtendedQueryTagDateTimeTableAlias;
break;
case SqlTableType.ExtendedQueryTagDoubleTable:
ret = ExtendedQueryTagDoubleTableAlias;
break;
case SqlTableType.ExtendedQueryTagPersonNameTable:
ret = ExtendedQueryTagPersonNameTableAlias;
break;
case SqlTableType.ExtendedQueryTagStringTable:
ret = ExtendedQueryTagStringTableAlias;
break;
}
if (string.IsNullOrEmpty(ret))
{
Debug.Fail("Invalid table type");
return null;
}
return ret + extendedQueryTagKey;
}