public object Get(Movies request) { var response = new MoviesResponse(); DbFactory.Exec(dbCmd => { if (request.Id != null) { var movie = dbCmd.GetByIdOrDefault <Movie>(request.Id); if (movie != null) { response.Movies.Add(movie); } } else { response.Movies = dbCmd.Select <Movie>(); } }); return(response); }
public object Get(Movies request) { var response = new MoviesResponse(); using (var dbConn = ConnectionFactory.OpenDbConnection()) using (var dbCmd = dbConn.CreateCommand()) { if (request.Id != null) { var movie = dbCmd.GetByIdOrDefault <Movie>(request.Id); if (movie != null) { response.Movies.Add(movie); } } else { response.Movies = dbCmd.Select <Movie>(); } } return(response); }