Design Question!!

• cutespn

  SSCommitted

  Points: 1669

  More actions

  February 18, 2005 at 9:48 am

  #166031

  Hi,

  Architecture of my application goes this way.

  All the DML Operations are done through sprocs, DAL(written in C#) accesses this sprocs.

  There is no error handling in the stored procedures, all the Sql execeptions are caught in the DAL(data access layer).

  Is this a good design, should there be error handling in stored procedures too??

   

  TIA,

  Sudheer

   

  "Careful programmers test early and test often.”

  http://spaces.msn.com/members/sudheerpalyam/

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  February 20, 2005 at 12:26 pm

  #543241

  If some thing can go wrong it will go wrong. that is a theory. therefore it will be very much advisable to stop every where error can occur

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/