//display info from high score
static void InfoFromDB()
{
Console.WriteLine("Press Enter to see high scores");
Console.ReadKey();
Console.Clear();
JayaEntities db = new JayaEntities();
List<HighScore> highScoreList = db.HighScores.Where(x => x.Game == "Trivia").OrderByDescending(x => x.Score).Take(10).ToList();
foreach (var item in highScoreList)
{
Console.WriteLine("{0}, {1}{2}", highScoreList.IndexOf(item) + 1, item.Name, item.Score);
}
}
//add to db
static void AddToDB()
{
//connection to db
JayaEntities db = new JayaEntities();
HighScore currentScore = new HighScore();
//add all info to current score
currentScore.DateCreated = DateTime.Now;
currentScore.Game = "Trivia";
currentScore.Name = name;
currentScore.Score = score;
db.HighScores.Add(currentScore);
db.SaveChanges();
}