The Complete Guide
Learn Entity Framework Core using Code First Methodology in ASP.NET Core 7 (.NET 7)
Lo que serás capaz de hacer
Entity Framework is a term that goes hand by hand with ASP.NET Core. It is one of that technology that is used very often and is not understood most of the time. This course will teach you everything you need to know about using Entity Framework Core with ASP.NET Core. The skills you will learn will help you to build and architect complex ASP.NET Core applications that make full use of Entity Framework Core with Code First. We will start with the basic fundamentals of Entity Framework Core and then we would dive into advanced concepts. Unlike other courses, which are outdated or do not convert all the topics. I have especially taken care to keep the course updated as well as cover topics from beginner to advanced topics with Entity Framework Core. By the end of watching this course, you'll be able to: Understand the basics of Entity Framework Core Use code-first migrations to push changes to the database, and learn how to manage them. Override code-first conventions (using data annotations and fluent API) Understand how LINQ works and how to filter data. Add, update and remove objects Apply best practices with Entity Framework Understand relationships in Entity Framework Core Bulk operations in Entity Framework Core Change tracker, RAW SQL, Stored Procs, View, and much more.
- Entity Framework Core
- Migrations in Entity Framework
- Fluent API
- Data Annotations
- Best practices with Entity Framework Core
- Relationships in Entity Framework Core
Temario
UNIDAD 1 - Introduction · 9 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Welcome
- ORM
- Entity Framework Core Introduction
- Get most out of the course
- Tools Needed
- Project Resources
- Create Project
- N Tier
- Nuget Packages and Console Application
UNIDAD 2 - Migrations · 17 leccionesUNIDAD 2 - Migrations
UNIDAD 2 - Migrations
- Create ApplicationDbContext and Book Model
- Configuring Connection String
- Add Migration
- Understanding Migration
- Apply Migration
- Migration Snapshot
- Remove Migration and Update Existing Table
- Assignment 1 - Add Migration
- Remove Nullable
- Assignment 1 - Solution
- Nullable Updates to Table
- Renaming Column
- When to Add Migration?
- Rolling back to Old Migrations
- Reverting back and Deleting Migration
- More Commands
- Seed Data Using Migration
UNIDAD 3 - Data Annotations · 6 leccionesUNIDAD 3 - Data Annotations
UNIDAD 3 - Data Annotations
- Update Table and Column Name
- Key and Required Data Annotations
- MaxLength and NotMapped
- EF Core Power Tools
- Assignment 2 - Add Models and Tables
- Assignment 2 Solution - Add Models and Tables
UNIDAD 4 - Relations in EF Core · 9 leccionesUNIDAD 4 - Relations in EF Core
UNIDAD 4 - Relations in EF Core
- One to One
- Demo - One to One
- Correcting "One to One" Relation
- "One to Many" Relation
- Demo - "One to Many" and Apply Migrations
- Demo - One to Many
- Many to Many - Skip Mapping Table
- Many to Many - Manual Mapping Table
- Relation Mapping Summary
UNIDAD 5 - Fluent API · 12 leccionesUNIDAD 5 - Fluent API
UNIDAD 5 - Fluent API
- Setup Models for Fluent API
- Table and Column Name in Fluent API
- Required and Primary Key with Fluent API
- Not Mapped and Max Length with Fluent API
- Assignment 3 - Fluent API
- Assignment 3 Solution - Fluent API
- "One to One" Relation
- "One to Many" relation
- "Many to Many" - Skip Mapping Table
- "Many to Many" Manual Table
- How Smart EF Core is?
- Organize Fluent API
UNIDAD 6 - Filtering Query · 16 leccionesUNIDAD 6 - Filtering Query
UNIDAD 6 - Filtering Query
- Database Helper Methods
- Get All Books
- Creating Book
- Logging Query
- First and First or Default
- Filter Using Where
- FirstOrDefault
- Find
- Single and SingleOrDefault
- Contains, Like, and Aggregation
- Deferred Execution Overview
- Sorting Data
- Pagination Methods
- Update in EF Core
- Deleting Record in EF Core
- Async Methods
UNIDAD 7 - EF Core CRUD · 13 leccionesUNIDAD 7 - EF Core CRUD
UNIDAD 7 - EF Core CRUD
- Setup EF Core in Web Project
- Seed Category and Logging in EF Core
- Retrieve using EF Core
- Create and Update Get Action Method
- Create and Update Category EF Core
- Delete Category
- Assignment 4 - Code Should not Throw Exception
- Assignment 4 - Solution - No Exception Thrown
- Bulk Insert
- Bulk Remove
- Setup Author and Publisher Views
- Assignment 5 - Publisher and Author
- Assignment 5 - Solution - Publisher and Author CRUD
UNIDAD 8 - Book Managment · 11 leccionesUNIDAD 8 - Book Managment
UNIDAD 8 - Book Managment
- List all Books
- Projections in EF Core
- Book Upsert View
- Upsert and Delete in Action
- Explicit Loading in EF Core
- Load Book Details View
- Book Details in Action
- Correct Way of using Book Details
- Eager Loading
- Deferred Execution
- IQueryable vs IEnumerable
UNIDAD 9 - Book and Author Assignment · 8 leccionesUNIDAD 9 - Book and Author Assignment
UNIDAD 9 - Book and Author Assignment
- Book Author VM
- NOT IN LINQ Clause
- Assign Author to Book
- Remove Author from Book - "Many to Many' Relation
- Multi-Level Explicit Loading
- Eager Loading on Fire
- Lazy Loading Related Data
- Summarize Loading of Related Data
UNIDAD 10 - Advance Concepts · 7 leccionesUNIDAD 10 - Advance Concepts
UNIDAD 10 - Advance Concepts
- Change Tracker Demo
- Tracking Vs No Tracking
- Create View and Stored Proc
- Views in Action
- Raw SQL
- Executing Stored Proc
- Bonus - Change Schema and Table Name for .NET Identity (Youtube Video)
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
10 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Bhrugen Patel - (DotNetMastery | Microsoft MVP | 300k+ Students).
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 10 unidades · 108 lecciones · 50 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Bhrugen Patel - (DotNetMastery | Microsoft MVP | 300k+ Students); INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
