If you've ever done it in MVC without stored procedure than you already should know the answer. Using stored procedure in opposed to dynamic sql statement (or ORM if you are using one) doesn't make MVC work any different. You retrieve data into your OBJECT and pass it to your view. What do you use to access data? LINQ to SQL? Entity Framework, NHibernate, other ORM? Straight ADO.NET?