// GET: api/Match/5 public MatchTbl Get(int id) { using (databaseSpeerkEntities entities = new databaseSpeerkEntities()) { return(entities.MatchTbls.FirstOrDefault(m => m.id == id)); } }
// POST: api/Match public void Post([FromBody] MatchTbl match) { using (databaseSpeerkEntities entities = new databaseSpeerkEntities()) { entities.MatchTbls.Add(match); try { entities.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } var message = Request.CreateResponse(HttpStatusCode.Created, match); } }
// GET: api/Match public IEnumerable <MatchTbl> Get() { // List<Match> matches = new List<Match>(); using (databaseSpeerkEntities entities = new databaseSpeerkEntities()) { entities.Database.Connection.Open(); return(entities.MatchTbls.ToList()); //return matches; } //return Make(); }