[mking1024]

In the .NET world we have Dapper (https://github.com/StackExchange/dapper-dot-net), which lets us write queries in plain old SQL. It's a very useful little library. I believe StackOverflow use it for their data access.

Example:

  var posts = connection.Query<Post>("select * from posts where user_id = @UserId", param: new { UserId = 1 });

[arethuza]

I really like Dapper - allows you to write "raw" SQL but does the tedious bit of mapping to/from objects in a nice way.