get record by name in sqlite xamarin code example

Example: xamarin sqlite get each row of table

public List<AlbumTable> getalldata() {
        try {
            using (var connection = new SQLiteConnection(Path.Combine(dir.AbsolutePath, "album.db"))) {
                return connection.Table<AlbumTable>().ToList();
            }
        }
        catch (SQLiteException ex) {
            return null;
        }
    }