public List<ChecksummedFile> GetChecksummedFiles()
{
List<ChecksummedFile> result = new List<ChecksummedFile>();
SQLiteCommand command = new SQLiteCommand("SELECT localPath, checksum FROM files;", GetSQLiteConnection());
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ChecksummedFile file = new ChecksummedFile((string)reader["localPath"], (string)reader["checksum"]);
result.Add(file);
}
return result;
}