title: Use a lot of stored procedures from C#
body: <p>I'm looking at a project where the customer has a legacy database (MS SQL) with a lot of sps (around 250). I need to be able to talk to all of these from my C# project but trying to find a good way to generate as much of the plumbing as possible.</p>
  
  <p>I'm not sure if I should go with an ORM or some code generation tool? Pros and cons? I've looked at entity framework and it's ability to use complex types as strongly typed models but I would rather have a poco model and populate my objects in some way. It seems that miniORMs like ie. PetaPoco could be the way to go?</p>
  
  <p>Anyone that has any tips and thoughts to share on this issue?</p>