Enrolment options
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
18
•
Activities:
0
•
Resources:
180
- 001-Welcome
- 002-ORM
- 003-Entity Framework Core Introduction
- 004-Tools Needed
- 005-Project Resources
- 006-Create Project
- 007-N Tier
- 008-Nuget Packages and Console Application
- 009-Create ApplicationDbContext and Book Model
- 010-Configuring Connection String
- 011-Add Migration
- 012-Understanding Migration
- 013-Apply Migration
- 014-Migration Snapshot
- 015-Remove Migration and Update Existing Table
- 016-Assignment 1 Add Migration
- 017-Remove Nullable
- 018-Assignment 1 Solution
- 019-Nullable Updates to Table
- 020-Renaming Column
- 021-When to Add Migration
- 022-Rolling back to Old Migrations
- 023-Reverting back and Deleting Migration
- 024-More Commands
- 025-Seed Data Using Migration
- 026-Update Table and Column Name
- 027-Key and Required Data Annotations
- 028-MaxLength and NotMapped
- 029-EF Core Power Tools
- 030-Assignment 2 Add Models and Tables
- 031-Assignment 2 Solution Add Models and Tables
- 032-One to One
- 033-Demo One to One
- 034-Correcting One to One Relation
- 035-One to Many Relation
- 036-Demo One to Many and Apply Migrations
- 037-Demo One to Many
- 038-Many to Many Skip Mapping Table
- 039-Many to Many Manual Mapping Table
- 040-Relation Mapping Summary
- 041-Setup Models for Fluent API
- 042-Table and Column Name in Fluent API
- 043-Required and Primary Key with Fluent API
- 044-Not Mapped and Max Length with Fluent API
- 045-Assignment 3 Fluent API
- 046-Assignment 3 Solution Fluent AP
- 047-One to One Relation
- 048-One to Many relation
- 049-Many to Many Skip Mapping Table
- 050-Many to Many Manual Table
- 051-How Smart EF Core is
- 052-Organize Fluent API
- 053-Database Helper Methods
- 054-Get All Books
- 055-Creating Book
- 056-Logging Query
- 057-First and First or Default
- 058-Filter Using Where
- 059-FirstOrDefault
- 060-Find
- 061-Single and SingleOrDefault
- 062-Contains Like and Aggregation
- 063-Deferred Execution Overview
- 064-Sorting Data
- 065-Pagination Methods
- 066-Update in EF Core
- 067-Deleting Record in EF Core
- 068-Async Methods
- 069-Setup EF Core in Web Project
- 070-Seed Category and Logging in EF Core
- 071-Retrieve using EF Core
- 072-Create and Update Get Action Method
- 073-Create and Update Category EF Core
- 074-Delete Category
- 075-Assignment 4 Code Should not Throw Exception
- 076-Assignment 4 Solution No Exception Thrown
- 077-Bulk Insert
- 078-Bulk Remove
- 079-Setup Author and Publisher Views
- 080-Assignment 5 Publisher and Author
- 081-Assignment 5 Solution Publisher and Author CRUD
- 082-List all Books
- 083-Projections in EF Core
- 084-Book Upsert View
- 085-Upsert and Delete in Action
- 086-Explicit Loading in EF Core
- 087-Load Book Details View
- 088-Book Details in Action
- 089-Correct Way of using Book Details
- 090-Eager Loading-
- 091-Deferred Execution
- 092-IQueryable vs IEnumerable Maybe
- 093-Attach vs Update
- 094-Book Author VM
- 095-NOT IN LINQ Clause
- 096-Assign Author to Book
- 097-Remove Author from Book Many to Many Relation
- 098-Multi Level Explicit Loading
- 099-Eager Loading on Fire
- 100-Lazy Loading Related Data
- 101-Summarize Loading of Related Data
- 102-Change Tracker Demo
- 103-Tracking Vs No Tracking
- 104-Create View and Stored Proc
- 105-Views in Action
- 106-Raw SQL
- 107-Executing Stored Proc
- 108-Welcome
- 109-ORM
- 110-Entity framework core Introduction
- 112-Tools needed
- 113-GitHub and Project Snippets Project Resources
- 114-Create Project
- 115-N Tier
- 116-Entity Framework Core Packages
- 117-Add Connection String
- 118-DbContext
- 119-Create Category Model
- 120-What are migrations
- 121-Add Migration
- 122-Push Migration to Database
- 123-Add Genre Model and Migration
- 124-Modify Migration
- 125-Migration Modification Scenarios Part 1
- 126-Migration Modification Scenarios Part 2
- 127-Reviews
- 128-What are conventions
- 129-Table Name and Column Name
- 130-Required and Primary Key
- 131-Max Length and Not Mapped
- 132-Add more Models
- 133-Database Generated Options
- 134-Add Foreign Key
- 136-One To Many Relationship
- 137-Many to Many Relationship
- 138-Models for Fluent API
- 139-Primary Key and Required
- 140-Smartness of Entity Framework Core
- 141-Not Mapped and Max Length
- 142-Table Name and Column Name
- 143-One to One Fluent API
- 144-One to Many Fluent API
- 145-Many to Many Fluent API
- 146-Fluent API Code Roganization
- 147-Insert Record with Migrations and Logging
- 148-Reading using Entity Framework Core
- 149-Create Update Fetch Records
- 150-Insert and Edit in Entity Framework Core
- 151-Delete in Entity Framework Core
- 152-Bulk Operations in Entity Framework Core
- 153-7 Bulk Remove in Entity Framework Core
- 154-Assignment Setup Author and Publisher
- 155-Assignment Solution Publisher and Author
- 156-Book Index Action
- 157-Projections in Entity Framework Core
- 158-Book Upsert View
- 159-Create and Update Book
- 160-Explicit Loading
- 161-Book Details Actions
- 162-Book Details in Action
- 163-Problem and Eager Loading
- 164-Deffered Execution
- 165-Demo Deferred Execution
- 166-IQueryable vs IEnumerable
- 167-Attach vs Update
- 168-Updating Entity Manually
- 169-Overview
- 170-Book Author VM and Get Action
- 171-NOT IN LINQ Clause
- 172-Many to Many Demo
- 173-Multi Level Explicit Loading
- 174-Eager Loading on Fire
- 175-Change Tracker
- 176-Change Tracker Demo
- 177-Tracking vs no tracking
- 178-Create View and Sproc
- 179-Map View in DbContext
- 180-Retrieve Data from Views
- 181-Raw SQL
- 182-Include Filters