I have seen lots of articles but none really help me. That is because I want to use dapper as a DAL. Should I create repositories with special functions? Like getStaffActive()?

If I use repositories

• I can implement with dapper-extension a generic crud
• I have no idea how to handle database connection. Where to open the connection? If I do this at every function then how am I supposed to use transaction scope?

Somehow the repositories I work with should share a connection in order transaction to work. But how to do this? Openning connection in BLL?

If I use queries and execute them directly then still the same thing.