Old Database Access
  • Prepare SQL statement
  • Issue query
  • Get a record
  • Fetch fields from record
Problems
  • SQL vs objects
  • Format conversion
  • Database adaptas different
  • SQL differences 
  • Security problems 
New Database Access -
Object Relational Mapping
  • Use objects for records
  • Manages movement of data (ensures backend data has been updated as well) to and from database 
  • Additional support for relationships between tables.   
Records look like:
table -> class -> model
row -> object
column -> attribute 
Overview
C - create
R - read
U - update
D - delete
   Login to remove ads X
Feedback | How-To