/// <summary> /// Gets an IDataReader with all rows in the cy_IndexingQueue table. /// </summary> public static DataTable GetIndexPaths() { StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("SELECT DISTINCT IndexPath "); sqlCommand.Append("FROM cy_IndexingQueue "); sqlCommand.Append("ORDER BY IndexPath "); sqlCommand.Append(";"); IDataReader reader = SqliteHelper.ExecuteReader( GetConnectionString(), sqlCommand.ToString(), null); return(DBPortal.GetTableFromDataReader(reader)); }