Data Access with Entity Framework Core
Entity Framework Core (EF Core) is Microsoft's newest version of the Entity Framework, designed from the ground up to be a lightweight, extensible, and cross-platform version of Entity Framework, Microsoft's Object-Relational Mapping (ORM) technology. EF Core allows you to access and manipulate data in your database without creating your own data-access layer, allowing you to concentrate on developing the models and business logic needed to run your application, while Entity Framework handles the data access and database query generation.
In this course, you will get a detailed introduction to Entity Framework. We will start off by discussing the basics of EF Core, including the differences between EF Core and EF6, how to install EF Core, and how to build models and use LINQ query expressions or method queries to query your models, and ultimately your database. We will then move on to how we can use a "code-first" strategy to build our models and use migrations to create and update our database artifacts. Finally, we will spend some time looking at how we can create, read, update, and delete (CRUD) data from our database using EF Core for models and their related entities.
After completing this course, you will be able to:
- Model a database through classes
- Model one-to-one, one-to-many, and many-to-many relationships
- Create a new database or modify an existing database through database migrations
- Query data using LINQ and Entity Framework Core
- Work with relational data and eager/explicit loading
- Modify and delete data using LINQ and Entity Framework Core
- Create a model from an existing database using scaffolding
- Know when EF Core is the correct technology to use