title: Automatically create C# wrapper classes around stored procedures
body: <p>I've inherited a rather large application that really could use some cleanup. There is data access code littered throughout the application. In code behinds, some in business logic classes, some inline in in classic asp pages. </p>
  
  <p>What I'd like to do is refactor this code, removing all the data access code into a few DAL classes. </p>
  
  <p>All the data access is done through stored procedures (Microsoft SQL 2000). There are 300-400 of them.</p>
  
  <p>It seems like there should be an automated way to analyse the store procedures, and automatically generate c# methods for each of them, mapping the Method parameters to the stored procedure parameters, with a method returning a datatable. </p>
  
  <p>I don't have any experience with ORM products, and I'm not sure if what I'm looking for is a full blown ORM, or just a 3rd party utility that will help generate simple wrappers around the sp calls.</p>