Please enable JavaScript.
Coggle requires JavaScript to display documents.
.Net core, OOD
(Object oriented design), OOP, Database, Design Pattern -…
.Net core
EF
related entities
Lazy loading:
means that the related data is transparently loaded from the database when the navigation property is accessed (multiple query)
- use with proxies
- Can cause N + 1 problem
Eager loading:
means that the related data is loaded from the database as part of the initial query (single query)
-
-
-
Database
ACID
A- Atomicity:
require either transaction as a while be successfully executed or if a part of the transaction fails, then the entire transaction be invalidated
C - Consistency
the data written to the database as part of the transaction must adhere to all defined rules, restrictions including constraints, cascades, triggers
I - Isolation
critical to achieving concurrency control and makes sure each transaction is independent unto itself.
D - Durability
requires that all of the changes made to the database be permanent once a transaction is successfully completed.
-