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