title: Calling stored procedures
body: <p>I have a c# application that interfaces with the database only through stored procedures. I have tried various techniques for calling stored procedures. At the root is the SqlCommand class, however I would like to achieve several things:</p>
  
  <ul>
  <li>make the interface between c# and sql smoother, so that procedure calls look more like c# function calls</li>
  <li>have an easy way to determine whether a given stored procedure is called anywhere in code.</li>
  <li>make the creation of a procedure call quick and easy.</li>
  </ul>
  
  <p>I have explored various avenues. In one, I had a project that with its namespace structure mirrored the name structure of stored procedures, that way I could generate the name of the stored procedure from the name of the class, and I could tell whether a given stored procedure was in use by fining it in the namespace tree. What are some other experiences?</p>