Repository implementation using ADO.NET SqlConnectin DataReader ... all that stuff

Question

Possible Duplicate:
Repository pattern tutorial in C#

anybody knows where can I find an example of Repository Implementation using just ADO.NET without any 3rd party components like Nhibernate

Answer 1

It's not a simple Repository implementation and it might be more than you are looking for, but Davy Brion's build your own DAL series contains everything you need to build up a serious data access layer. Using that, simply use any type of repository you like and substitute the specifics with this data access technique (see this post for instance).

Alternatively, just wrap ADO.NET code in repositories, put the common stuff in a BaseRepository of some sort and you're off. Usually when I need to write this type of plumbing code, I grab a version of the CSLA framework; not as an architecture, but as a source of easy to grab/grasp ADO.NET coding.