As a note - I've done a lot of SQL in C#, and Stack Overflow's Dapper[0] library is _fantastic_ for dealing with that. You can pass in all the SQL you like, or a stored procedure, and it deals with virtually all of the query parameterization and boilerplate around getting results out of the DB. It's saved me hours of tedium and typing.
It's the perfect micro-ORM. Eliminates boilerplate, gets out of the way otherwise.
It's the perfect micro-ORM. Eliminates boilerplate, gets out of the way otherwise.
[0] https://github.com/StackExchange/Dapper