If you are a fans of ADO .Net and want to stick with it because you dont want to migrate to EF yet, then here is a tool for you to generate repository classes using ADO .Net. Or in other word it is a data access layer generator tool

Database: SQL Server

Language: C# and Visual Basic

It's recommended to create a separated project (class library) to put the generated code.

1. Open The App (Build/Run the project)

2. Pick Language (C# or VB)

3. Login using sql server password or windows

4. Select a database node and click 'Generate Repository' Context Menu

5. Type your namespace name, DbContext name, and select a folder project where you want to generate the files.

6. In your IDE (visual studio) point to project where the files generated. Show all files, select the generated folders and files then include to your project

7. Note that the dbcontext class will read connection string from config file(app.config or web.config). So you must add/create your own connection string in the config file

It's a bit similiar to how we use an EF dbcontext object.