Are there open source alternatives that come with caching support, etc.
While not open source, I would recommend checking out Entity Framework .
Regarding caching when using entity framework, you can check this article. And another SO thread that also talks about caching.