コード例 #1
0
        /// <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));
        }