/// <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;");
}
}
