I use Dapper [1] at work, along with lots of hand written SQL. All the SQL is in a single data access library, which is easy to both mock and test in isolation

I use Dapper [1] at work, along with lots of hand written SQL. All the SQL is in a single data access library, which is easy to both mock and test in isolation (there are several tests that run against a real database mainly for some of the more complex queries). You write regular SQL, can easily parametrize everything, and get collections of objects back. And it's very fast. [1] https://github.com/StackExchange/Dapper https://github.com/StackExchange/Dapper