3.1 - Validating Data

3.1 - Validating Data

1. Data Integrity

   • Domain Integrity
     • Where data originates or is meant for
   • Referential
     • Relationships (PK and FK)
   • NTT
     • Each record should be uniquely identifiable (CRM GUID, DB2 PK)
   • User-Defined
     • Related to business rules
   • Leads to (custom) exceptions

2. Manipulating data for validation

   • PARSE or TRYPARSE
     • TRYPARSE better, as less harsh
   • Convert
     • Allows null values
     • Supported - Int,
   • REGEX
     • Allow for quicker validations (less code)

3. JSON and XML

   • Most common data from other apps
   • JSON begins with {, [, } or ]
   • XML defined with XSD, therefore schema validated against that