public IHttpActionResult Get(int id) //GET http://localhost:49677/api/artists/id
        {
            Band band;

            using (var context = new Context()) 
            {
                band = context.Bands.Find(id);  //Where(b => b.Id == id).FirstOrDefault();
                context.Entry(band).Collection(a => a.Albums).Load(); //explicit load. i have disabled lazy loading
            }

            if (band == null)
                return NotFound();
            else
                return Ok(band);
        }
        public IHttpActionResult Put(int id, [FromBody] Band updateValues) //PUT http://localhost:49677/api/artists/id , update values in body
        {
            if (!ModelState.IsValid)
                return BadRequest(ModelState);
            else
            {
                Band band;
                using (var context = new Context())
                {
                    band = context.Bands.Where(b => b.Id == id).FirstOrDefault();                  
                }

                if (band != null)
                {
                    band.Name = updateValues.Name; //does updates in disconnnected state
                    band.Rating = updateValues.Rating;

                    using (var context = new Context()) //open new context, save update
                    {
                        context.Bands.Attach(band);
                        context.Entry(band).State = EntityState.Modified;
                        context.SaveChanges();
                    }

                    return Ok();
                }
                else
                    return NotFound();
            }
        }