public static List<Favourite> FetchAll()
{
List<Favourite> items = new List<Favourite>();
using (SQLiteCommand command = new SQLiteCommand("select " + Columns + " from favourites, programmes where favourites.progid=programmes.progid", FetchDbConn()))
{
using (SQLiteMonDataReader reader = new SQLiteMonDataReader(command.ExecuteReader()))
{
while (reader.Read())
{
items.Add(new Favourite(reader));
}
}
}
return items;
}