For what it is worth, we have always found it far easier to use stored procedures and manintain them in the DB, rather than do it all from code.

You can always the code obscurity by writing a more user-friendly class, and use that class to access the SP.