title: Does WCF cache stored procedures
body: <p>I have a WCF service that my client makes a call to telling it to run <code>storedprocedure1</code>, with <code>param1, param2</code>, etc.</p>
  
  <p>When the WCF service gets this call, it instantiates a class that instantiates a DAO class.
  The DAO class creates the connection, loads the parameters into a <code>SqlCommand</code> object, then executes the object.</p>
  
  <p>After finishing, it closes the <code>SqlConnection</code>, but does not close or dispose the DAO class, because there are multiple procedures it needs to run.</p>
  
  <p>Here's the problem. If I edit <code>storedprocedure1</code> and then call it through the WCF service, the changes I made in <code>storedprocedure1</code> are not reflected until I restart the WCF service. Its like the <code>storedprocedure1</code> is cached in WCF.</p>
  
  <p>Has anyone else experienced this and is there a solution?</p>