November 2002
Intermediate to advanced
560 pages
16h 4m
English
Content preview from Patterns of Enterprise Application Architecture
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 10. Data Source Architectural Patterns
Table Data Gateway
An object that acts as a Gateway (466) to a database table. One instance handles all the rows in the table.
Mixing SQL in application logic can cause several problems. Many developers aren’t comfortable with SQL, and many who are comfortable may not write it well. Database administrators need to be able to find SQL easily so they can figure out how to tune and evolve the database.
A Table Data Gateway holds all the SQL for accessing a single table or view: selects, inserts, updates, and deletes. Other code calls its methods for all interaction with the database.