Implementing repository pattern with the ado.net entity model
There are lots of ways to implement repository pattern but with ado.net entity model you can create repository pattern within 10 to 15 minutes. If you are creating asp.net mvc application then just right click->Model folder->Add->Net Item->select ado.net entity data model. From database explorer right click and drag your tables to your database explorer. It