I like using what is sometimes called Micro-ORM. Basically it does the mapping of query results to objects and sometimes has a basic query builder but you mostly use raw sql.

Dapper (https://github.com/StackExchange/Dapper) is a great one for .NET.