Untitled

        public static bool Exists(String itemName)
        {
            bool exists = false;

            using (SQLiteConnection conn = new SQLiteConnection(CONN_STRING))
            {
                conn.Open();
                using (SQLiteCommand selectCommand = conn.CreateCommand())
                {
                    selectCommand.CommandText = SELECT_STATEMENT;
                    SQLiteParameter nameParam = new SQLiteParameter("@Name");
                    selectCommand.Parameters.Add(nameParam);
                    nameParam.Value = itemName;

                    SQLiteDataReader reader = selectCommand.ExecuteReader();
                    exists = reader.HasRows;
                }
            }

            return exists;
        }