1
Vote

Handling of IsDeleted column

description

If a table contains a column named IsDeleted then
 
  1. GetSingle procedure must check that IsDeleted = 'N'
  2. List procedure must check that IsDeleted = 'N'
  3. Update procedure should not update IsDeleted field
  4. Delete procedure should set IsDeleted = 'Y'

comments