Add context manager support to Resource provider #1275

Job	Run time
Run tests with different pydantic versions	3m 19s
Run tests (3.11)	1m 58s
Run tests (3.9)	1m 45s
Run tests (3.12)	1m 47s
Run tests (3.8)	1m 52s
Run tests (3.13)	1m 48s
Run linters (pydocstyle)	1m 28s
Run linters (flake8)	1m 31s
Run tests with coverage	2m 50s
Run linters (pylint)	1m 32s
Run tests (3.10)	1m 48s
Run linters (mypy)	1m 37s
	23m 15s

Provide feedback