public void ClearScores() { using (var context = new ReversiContext()) { context.Database.ExecuteSqlCommand("DELETE FROM Scores"); } }
public void DeleteComment() { using (var context = new ReversiContext()) { context.Database.ExecuteSqlCommand("DELETE FROM Comments"); } }
public void AddScore(Score score) { using (var context = new ReversiContext()) { context.Scores.Add(score); context.SaveChanges(); } }
public void AddComment(Comment comment) { using (var context = new ReversiContext()) { context.Add(comment); context.SaveChanges(); } }
public int GetRating() { using (var context = new ReversiContext()) { // return context.Database.ExecuteSqlCommand("SELECT AVG(rating) FROM Rating "); int a = (int)(from s in context.Ratings select s.rating).Average(); return(a); } }
public void AddRating(Rating rating) { using (var context = new ReversiContext()) { context.Add(rating); context.SaveChanges(); } }
public List <Score> GetTopScores() { using (var context = new ReversiContext()) { return((from s in context.Scores orderby s.Points descending select s).Take(5).ToList()); } }
public List <Comment> GetComments() { using (var context = new ReversiContext()) { //context.Database.ExecuteSqlCommand("SELECT * FROM Comments"); return((from s in context.Comments orderby s.Coment select s).ToList()); } }