Summary: Working with Data Using Entity Framework Core

We gained essential skills in working with Entity Framework. We discovered how to establish connections and construct entity data models based on existing databases, enabling us to execute LINQ queries efficiently and handle their results. Moreover, we learned about filtered includes, enabling more precise data retrieval. We also covered the crucial aspects of adding, modifying, and deleting data from the database. Furthermore, we delved into creating a Code First model, a powerful approach to define our data model in code and subsequently utilize it to generate new databases and populate them with data, granting you a versatile set of tools for working with databases in Entity Framework.

Let’s recap the key takeaways:

• Connect to and build entity data models for an existing database.

• Execute a simple LINQ query and process the results.

• Use filtered includes.

• Add, modify, and delete data.

• Define a Code First model and use it to create a new database and populate it with data.