public List <ScoreBoard> GetData() { List <ScoreBoard> data_records; using (SnekScoreBoardEntities context = new SnekScoreBoardEntities()) { data_records = context.ScoreBoards .ToList(); } return(data_records); }
public List <ScoreBoard> GetTop10() { List <ScoreBoard> data_records; using (SnekScoreBoardEntities context = new SnekScoreBoardEntities()) { data_records = context.ScoreBoards .OrderByDescending(e => e.Score) .Take(10) .ToList(); } return(data_records); }
public void save_to_DB(int score, DateTime date) { using (SnekScoreBoardEntities context = new SnekScoreBoardEntities()) { ScoreBoard s = new ScoreBoard() { Score = score, Date = date }; context.ScoreBoards.Add(s); context.SaveChanges(); } }