EF Core Flashcards
What is EF Core
EF core is a lightweight, extensible data access technology which can serve as an ORM. This allows developers to work the entities in code rather than SQL.
What is an ORM
The Object part is the one you use with your programming language ( python in this case )
The Relational part is a Relational Database Manager System ( A database that is ) there are other types of databases but the most popular is relational ( you know tables, columns, pk fk etc eg Oracle MySQL, MS-SQL )
And finally the Mapping part is where you do a bridge between your objects and your tables.
Problems with EF / ORM?
Does not get away from key knowledge for DB, PK, FK, indexes, constraints, profiling
Key to ensure performance
Recovery, migrations
Things to think about
Tracking / No Tracking
Casecade on Delete
Handling conflicts - optimistic concurrency control,
Efficient querying - indexes (filters only a subset), query plan, index vs scan, project only properties you need
meaning that it will let multiple processes or users make changes independently without the overhead of synchronization or locking. In the ideal situation, these changes will not interfere with each other and therefore will be able to succeed. In the worst case scenario, two or more processes will attempt to make conflicting changes, and only one of them should succeed.
