VietMX Staff asked 3 years ago
Very often, you will find SQL queries scattered in the codebase and when you come to add a column to a table you have to search code files to try and find usages of a table. The impact of the change is far-reaching. With the repository pattern, you would only need to change one object and one repository. The impact is very small.
Basically, repository hides the details of how exactly the data is being fetched/persisted from/to the database. Under the covers:
- for reading, it creates the query satisfying the supplied criteria and returns the result set
- for writing, it issues the commands necessary to make the underlying persistence engine (e.g. an SQL database) save the data
