/// <summary> /// Pulls a random joke from the database and returns it /// </summary> /// <returns></returns> public static Joke QueryRandomJoke() { Joke joke = null; using (SqliteConnection connection = OpenDatabase()) { using (SqliteCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM TJokes WHERE jokeID IN (SELECT jokeID FROM TJokes ORDER BY RANDOM() LIMIT 1)"; SqliteDataReader reader = command.ExecuteReader(); reader.Read(); joke = Joke.FromDataRow(reader); reader.Close(); } } return(joke); }