public static List<Movie> Get()
{
var list = new List<Movie>();
var connection = GetConnection ();
using (var cmd = connection.CreateCommand ()) {
connection.Open ();
cmd.CommandText = "SELECT * FROM Movie";
using (var reader = cmd.ExecuteReader ()) {
while (reader.Read ()) {
Movie m = new Movie();
m.Title = reader[1].ToString();
m.Rating = reader[2].ToString();
//list.Add(new Movie{ Title = reader[1], Rating = reader[2]});
list.Add(m);
}
}
connection.Close ();
}
return list;
}
private string Detail(Movie m)
{
return string.Format("Title:{0} \n Rated:{1}", m.Title, m.Rating);
}
