protected List<Image> loadRandomImagesFromDB(int _imageCount)
{
List<Image> imageList = new List<Image>();
try
{
this.connect();
SQLiteCommand command = new SQLiteCommand(connection);
SQLiteDataReader reader;
String key;
byte[] imageBytes;
command.CommandText = String.Format("SELECT * FROM imageData ORDER BY RANDOM() LIMIT {0};", _imageCount);
reader = command.ExecuteReader();
while (reader.Read())
{
key = reader.GetString(0);
imageBytes = (System.Byte[])reader["data"];
imageList.Add(this.byteArrayToImage(imageBytes));
}
command.Dispose();
this.close();
}
catch (Exception _exception)
{
// do nothing
}
return imageList;
}