I am developing apps in ASP.NET using Visual Studio 2005 with SS as my data store. I have several tables and SPs defined. I call these SPs in my application for data retrieval and manipulation. These SPs in turn perform operation on tables such as SELECT, INSERT, UPDATE, DELETE, etc.
Is this the recommended way to do things or do I need to add one more layer between my SPs and tables, the layer of viewes? My SPs then will only interact with views and views with tables.
Is there a great advantage in doing this or am I OK in the way I am currently doing things?