title: Retrieving Records and Saving to a Database in a single C# Web Service
body: <p>Hi i am trying to combine a C# webservice in azure with a get and a post at the same time, the idea is to get the details of a CD by the uniqueCDcode and the webservice outputs just the json information AND the uniqueCDcode needs to be stored in a different table CDClicked to i get a list of all the clickedCD's so i am able to take the last 50 as for trending etc. but don't really seem to get it to work. This is what i have so far</p>
  
  <pre><code>    //// WS# 00002 GET THE ALBUM DETAILS
      [Route("api/Music/Album/{uniqueCDcode}")]
      public HttpResponseMessage GetAlbum(int uniqueCDcode)
      {
          return Request.CreateResponse(HttpStatusCode.OK, 
              new { AlbumMusic = db.Music
                  .Where(am =&gt; am.uniqueCDcode == uniqueCDcode);
  
          db.CDClicked.Add(uniqueCDcode);
  
      }
  </code></pre>