// データを格納する. public void AddContent(TAHLocalDbEntry entry) { using (SQLiteCommand cmd = cnn.CreateCommand()) { // acpathを追加する. cmd.CommandText = "INSERT INTO Entry (PATH,DATAID,HASH) VALUES(@path,@id,@hash)"; cmd.Parameters.AddWithValue("path", entry.path); cmd.Parameters.AddWithValue("id", entry.dataid); cmd.Parameters.AddWithValue("hash", (int)entry.hash); cmd.ExecuteNonQuery(); } }
// エントリを取得する public TAHLocalDbEntry GetEntryHash(int hash) { TAHLocalDbEntry entry = null; using (SQLiteCommand cmd = cnn.CreateCommand()) { cmd.CommandText = "SELECT PATH,DATAID,HASH FROM Entry WHERE HASH=@hash"; cmd.Parameters.AddWithValue("hash", hash.ToString()); using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { entry = new TAHLocalDbEntry(); entry.path = reader[0].ToString(); entry.dataid = int.Parse(reader[1].ToString()); entry.hash = int.Parse(reader[2].ToString()); break; } } } return(entry); }