RaumfeldNET.ImageBuilder.loadRandomImagesFromDB C# (CSharp) Method

loadRandomImagesFromDB() protected method

protected loadRandomImagesFromDB ( int _imageCount ) : List
_imageCount int
return List
        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;
        }