title: How to use sql server 2005 stored procedures in asp.net mvc?
body: <p>I have just started a new web application with <code>asp.net mvc</code> and <code>sql server 2005</code>... Thus far in my webform applications i used <code>ADO.NET</code>... I want the same in my <code>asp.net MVC</code> apllication... </p>
  
  <p>I have a database in <code>sql server 2005</code> with all the <code>stored procedures</code>... Now i want to use those stored procedures in my MVC application... I dont use any <code>ORM</code>... I want to use ADO.NET..</p>
  
  <p>Any sample <code>controller</code> that calls a <code>model</code> which uses a <code>stored procedure</code> and returns a <code>Dataset</code> to the <code>controller</code> and then the <code>controller to View</code> to display records... Any suggestions...</p>