public object Get(RestMovies request) { var response = new RestMoviesResponse(); DbFactory.Exec(dbCmd => { if (request.Id != null) { var movie = dbCmd.GetByIdOrDefault <RestMovie>(request.Id); if (movie != null) { response.Movies.Add(movie); } } else { response.Movies = dbCmd.Select <RestMovie>(); } }); return(response); }
public object Get(RestMovies request) { var response = new RestMoviesResponse(); using (var db = DbFactory.Open()) { if (request.Id != null) { var movie = db.GetByIdOrDefault<RestMovie>(request.Id); if (movie != null) { response.Movies.Add(movie); } } else { response.Movies = db.Select<RestMovie>(); } }; return response; }
public object Get(RestMovies request) { var response = new RestMoviesResponse(); using (var db = DbFactory.Open()) { if (request.Id != null) { var movie = db.SingleById <RestMovie>(request.Id); if (movie != null) { response.Movies.Add(movie); } } else { response.Movies = db.Select <RestMovie>(); } }; return(response); }