public IHttpActionResult GetAll() { try { var music = _repository.GetAll("SELECT * FROM MUSICS"); _repository.Close(); music = _repository.GetAll("SELECT * FROM MUSICS"); return(Ok(music)); } catch (System.Exception) { throw; } finally { _repository.Close(); } }