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; }