MS FS & BE Database Integration and Management

Question 1

What is the primary purpose of Object-Relational Mapping (ORM)?

Answer 1

To translate data between objects in code and relational databases.

ORM helps translate data between objects in an application and relational database tables, simplifying database interactions.

ORM techniques and EF Core simplify backend development by enabling smoother database interactions, reducing code complexity, and supporting application growth.

Question 2

What is the purpose of SQL?

Answer 2

To manage and retrieve data in relational databases efficiently

SQL stands for Structured Query Language.

Question 3

What is the primary issue that ORM addresses?

Answer 3

The mismatch between object-oriented programming data representation and relational database storage

This reduces the risk of errors and complexity in managing data.

ORM links objects in code with relational tables.

Question 4

What is EF Core?

Answer 4

Entity Framework Core (EF Core) is an open-source ORM tool in the .NET ecosystem

EF Core allows developers to interact with relational databases using C# objects.

Question 5

What is one key feature of EF Core?

Answer 5

LINQ (Language Integrated Query)

LINQ integrates query capabilities directly into C# code.

Question 6

What does database migrations in EF Core allow?

Answer 6

The database schema to evolve alongside application development

This includes supporting changes like table additions or modifications.

Question 7

What is change tracking in EF Core?

Answer 7

Automatically tracks changes made to objects

This streamlines updating the database when data changes.