public IEnumerable <MovieDataModel> UpsertMovie(MovieRequest video) { using var sqlConnection = new SqlConnection(_configuration.CreateConnectionString()); var command = video.CreateMovieCommand(sqlConnection); return(ReadFromDatabase <MovieDataModel>(command)); }
public static void AddRequestItem(MovieRequest request, IConfiguration configuration) { var connection = configuration.CreateConnectionString(); using var sqlConnection = new SqlConnection(connection); var command = request.CreateMovieCommand(sqlConnection); command.Connection.Open(); command.ExecuteNonQuery(); command.Connection.Close(); }