When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

Deep Dive With Entity Framework Core 5

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Deep Dive With Entity Framework Core 5

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon5 hours 49 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Deep Dive With Entity Framework Core 5

Introduction

Setup Development Environment

Setting up the Solution

Creating the Data Models with EF Core

Specifying the Data Provider and Connection String

Migrations and Database Creation

Generate Migration Scripts

Reverse Engineer Existing Database

View Diagram with Entity Framework Core Tools

Adding Verbose Logging to EF Core’s Workload

Simple Insert Operations

Simple Select Operations

Filtering Records

Additional Execution Methods

Alternative LINQ Syntax

Simple Update Query

Simple Delete Query

Tracking Vs. No Tracking

Review One-to-Many Relationships

Adding Many-To-Many Relationships

Adding One-To-One Relationships

Generate New Entity Diagram

Inserting Related Data

(Eager Loading) Including Related Data

Projections and Anonymous Data Types

Filtering on Related Records

Adding Views and Other Data Objects

Querying Keyless Entities (Like Views)

Querying with Raw SQL

Add and Query Using Stored Procedures

Executing Non-Query Raw SQL

Seeding Data

Rolling Back Migrations

Manipulate Entries Before Saving Changes

Extending DbContext

Implement Full Database Auditing

UPDATE: Implement Full Database Auditing - Fix

Data Validation with Data Annotations

Fully Using Configuration Files

What You Will Learn?

  • Overview .
  • In this course, Deep Dive With Entity Framework Core 5, you will learn to work with data in your .NET applications..
  • Most times when course are created for .NET technologies, the details of Entity Framework and it's sheer power are neglected. We get distracted with abstractions and layers and don't focus on what Entity Framework is doing and can do..
  • In this course, we will review the general benefits of using Entity Framework Core 5, which is Microsoft’s flagship Object Relational Mapper (ORM), to relieve you of many concerns and challenges that come with this component of software development. We will also spend time discovering how to EF Core translates classes and references to Database Models and Relationships..
  • We will learn how to write queries, update databases incrementally, rollback changes and explore the myriad capabilities that Entity Framework Core affords us..
  • When you’re finished with this course, you’ll have the skills and knowledge of Entity Framework Core needed to fluidly interact with data and write quires for for .NET Core applications with ease..
  • By the end of watching this course, you'll be able to:.
  • Construct a data model using code-first and database-first workflows.
  • Understand Entity Framework Commands.
  • Use migrations to manage database changes.
  • Apply Database validations and constraints .
  • Perform CRUD operations using LINQ.
  • Apply best practices with Entity Framework.
  • Extending Data Contexts.
  • Understand how Change Tracking works.   .
  • Manage Database Structure using Fluent API.
  • Handle One-To-One, One-To-Many and Many-To-Many Relationships.
  • PREREQUISITES.
  • In order to take this course, you should have at least 3 months experience programming in C#. If you need to strengthen your C# fundamentals, you can take my C# beginner course C# Console and Windows Forms Development with LINQ & ADO.NET.
  • Content and Overview.
  • To take this course, you will need to have some knowledge of C#. Even if you do not have much exposure to the .NET development stack, this course is very beginner friendly and chock full of development tips..
  • This premium course is smartly broken up to highlight a set of related activities based on each module in the application that is being built. We will also look at troubleshooting and debugging errors as we go along; implementing best practices; writing efficient logic and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course and you will be challenged to be the best you can be..