We're going to do a longer blog post on this later, but if you don't want to use Massive for your sql mapper, maybe try out:

http://github.com/clotheshorse/destrier

works similarly in that you can map output to POCOs, but will also let you do more complex querying and CrUD operations.