Explore

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

4.5 hours on-demand video

$ 10.99

Save Course

Go to Course

Brief Introduction

Master Code & Db First Approach, Query API, Migrations & all Concepts of Entity Framework core with C# & .Net

Description

Entity Framework Core is the Default Technology in 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 blocks does EF core consist of
- DbContext
- POCOs
- Migrations
- Change Tracking
- and much more
Create a Database with the Code First Approach
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

Requirements

Requirements
Basic knowledge of .Net and C#
Basic Knowledge of SQL are helpful but not needed (teached in the course)
CLI proficiency might be helpful but general knowledge is appropriate

Recommended for you

MTA 98-361 Software Development Fundamentals C# Exam Prep

Be prepared for the Microsoft MTA 98-361 Software Development Fundamentals Exam with this 1 Stop Q&A Take your first steps towards becoming a Programmer/Software Developer!...

Save Course

C# data access: from ADO.NET to EF and Dapper

Learn basics of SQL Access with ADO. NET, Dapper, Entity Framework. NoSQL with Mongo and Redis. Also: DAL patterns For all of them the fundamental concepts are similar....

Save Course