sqlite-net-pcl get all 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;
}
}