Entity Framework core- SQL Data Access with C# .Net

Entity Framework core: SQL Data Access with C# & .Net, available at $54.99, has an average rating of 3.7, with 57 lectures, 2 quizzes, based on 17 reviews, and has 146 subscribers.

You will learn about Fundamentals of Entity Framework Core Code First & Database First Approach Migrations with Entity Framework Core ( Create, Revert, Database update and more ) Advanced topics like ChangeTracking, SQL Queries, Query Evaluation and Performance Bonus: SQL Basics, LINQ Basics, Docker Basics and VS Code This course is ideal for individuals who are .Net Developers or Enterprise Developers or professional developers with Microsoft Stack It is particularly useful for .Net Developers or Enterprise Developers or professional developers with Microsoft Stack.

Enroll now: Entity Framework core: SQL Data Access with C# & .Net

Summary

Title: Entity Framework core: SQL Data Access with C# & .Net

Price: $54.99

Average Rating: 3.7

Number of Lectures: 57

Number of Quizzes: 2

Number of Published Lectures: 57

Number of Published Quizzes: 2

Number of Curriculum Items: 62

Number of Published Curriculum Objects: 62

Original Price: 24.99

Quality Status: approved

Status: Live

What You Will Learn

Fundamentals of Entity Framework Core

Code First & Database First Approach

Migrations with Entity Framework Core ( Create, Revert, Database update and more )

Advanced topics like ChangeTracking, SQL Queries, Query Evaluation and Performance

Bonus: SQL Basics, LINQ Basics, Docker Basics and VS Code

Who Should Attend

.Net Developers

Enterprise Developers or professional developers with Microsoft Stack

Target Audiences

.Net Developers

Enterprise Developers or professional developers with Microsoft Stack

Entity Framework Core is the Default Technologyin terms of SQL Database access with dotnet core.

Almost every project with dotnet core nowadays will use it, so to push your skills, career and future salary you ought to learn this technology.

As a dotnet core Developer you cannot move around this technology. This is why I made this course so you can profit from expertise of many years as a freelance developer.

Learn in this course everything about the following topics:

What is Entity Framework Core all about and why do we need it?

What is an ORM (object relational mapper)?

Which basic building blocksdoes EF core consist of

DbContext

POCOs

Migrations

Change Tracking

and much more

Create a Database with the Code FirstApproach

Create the access code from an existing Database with the Database First Approach

Queries and Commands with the EF core Query API

Migrations:manage the database schema

ChangeTracking & Performance

Also this course offers lots and lots of source code, extra insights and downloadable contents. It also tests everything you learned in a section with a Quiz as well as an Assignment.

All topics are explained with a real world application which is in use to date (yet in a slightly simpliefied version).

As Database systems we use the following:

SQlite (easier to deliver with downloadable code)

PostgreSQL (probably the best open source SQL Database out there)

MariaDB (As MySQL fork the probably most used Open Source Database)

Additionally there is a Bonus Section with Introduction and Refreshers to the following topics:

Docker

SQL

LINQ

VS Code

ENROLL NOW,make use of my experience and support and put your career on the next step of the ladder.

All the best

Your Instructor

Timo

Course Curriculum

Chapter 1: What is Entity Framework Core and what do we need it for?

Lecture 1: What is EF? What is an ORM?

Lecture 2: Benefits & Drawbacks of EF core explained

Lecture 3: First Impression of EF core with SQlite and Database first approach

Lecture 4: Learn the basic concpets of EF core

Lecture 5: Working with the course materials

Lecture 6: Update Uploaded Code for the chapters.

Lecture 7: Summary of the first chapter

Chapter 2: Database first & Code first approach

Lecture 1: Introduction to the example Application and its entites for the course.

Lecture 2: Add the EF Core Providers as Nuget Packages for SQlite, MariaDb and PostgreSQL

Lecture 3: Create a Database with SQlite

Lecture 4: Database inside a Docker Container: PostgreSQL

Lecture 5: Extract the DbContext and Entities from the existing Databases

Lecture 6: Code First I: Create POCOs (Model Entities)

Lecture 7: Code First II: Create the DatabaseContext

Lecture 8: Code First III: Use the InitialMigration and update the Database

Lecture 9: Code First IV: Conventions and Attributes

Lecture 10: Summary Code first and Db First

Chapter 3: Utilize the Entity Framework Query API

Lecture 1: Introduction to DbContext and Querying

Lecture 2: Create UseCases for the Application

Lecture 3: Seed Data: Add AddRange and SaveChanges

Lecture 4: Query Interface with DbContext I: ToList, First, Single, Last and Any

Lecture 5: Query Interface with DbContext II: Include & ThenInclude

Lecture 6: Improve read speed with AsNoTracking

Lecture 7: Evaluation of Queries

Lecture 8: Any Query and Insert into Linking Tables

Lecture 9: Update and Delete with Entity Framework Core

Lecture 10: Summary of the Query Api so far

Chapter 4: Alter the Database with Entity Framework Core Migrations

Lecture 1: Introduction to Migrations

Lecture 2: Add a Property with Migrations

Lecture 3: Change a Migration manually

Lecture 4: Revert a failed Migration

Lecture 5: 3 Ways to apply Migrations to the Database

Lecture 6: Apply Migrations from Code and as SQL Script

Lecture 7: Alter Entity Relationships with Migrations

Lecture 8: Learn what Shadow Properties are and what they are used for.

Lecture 9: How to use Shadow Properties

Lecture 10: Summary Migrations

Chapter 5: Reporting on the Example Application (Lean Production Trainer)

Lecture 1: What do we want to find out about our data?

Lecture 2: Report 1: Product related time to produce

Lecture 3: Report 2: Which Station needs the most time to complete the work step?

Lecture 4: Report 3: Which step is the overall most costly one?

Chapter 6: Advanced Topics with Entity Framework Core

Lecture 1: Intro to the advanced Topics of Entity Framework core section

Lecture 2: Understand the ChangeTracking Feature

Lecture 3: Look deeper into ChangeTracking and control it manually

Lecture 4: Utilize ChangeTracking Events to handle it manually

Lecture 5: Understand how Raw SQL and Querytypes work and what we need them for

Lecture 6: RawSql: Execute SQL Statements directly with Entity Framework Core

Lecture 7: Query Types: Query MariaDB Views without Table or Table Entities

Lecture 8: Mapping explained with Logging for EF core

Lecture 9: Sql Inheritance explained with postgreSql database

Lecture 10: Inheritance with Entity Framework Core

Lecture 11: Summary of advanced Ef Core Concepts

Chapter 7: Bonus: Things you might want to know for this course

Lecture 1: LINQ Basics: Extension Methods

Lecture 2: LINQ Basics: Anonymous Types

Lecture 3: SQL Basics: Tables and Data Types

Lecture 4: SQL Basics: Relationships

Lecture 5: More Resources

Instructors

Timo | C# Development | .NET | DevOps
Freelancer & .Net developer

Rating Distribution

1 stars: 2 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 4 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!