private static string GetTableAlias()

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;
        }