/// <summary> /// Returns command text for searching publications based upon the provided <see cref="SearchType"/> /// </summary> /// <returns></returns> private string GetPublicationsBySearchCommandText() { if (SearchType == SearchTypes.Date) { return(string.Empty); } else { return($"SELECT * FROM Publications WHERE {SearchType.GetColumnIDBySearchType()} LIKE @Search;"); } }