Learn Entity Framework Core 2.0 (EFC2) using ASP.Net Core

This course will give you a low level understanding of Entity Framework Core 2 & how to use it ASP.Net Core.

Created by Nilay Mehta, Last Updated 10-Oct-2020, Language:English

What Will I Get ?

Perform CRUD operations
Code First & Data First Approach
Migration & Seeding
Advance Model Designing
Advance Data Operations

Requirements

Basic Asp. Net development & C# concepts
Basic knowledge of SQL server

Description

The Entity Framework is a set of technologies that support the development of data-oriented applications to work with relational data. It is is an ORM.

The Entity Framework provides services like tracking, identity resolution, lazy loading, and query translation so that developers can focus on their application-specific business logic rather than the data access fundamentals. It enables developers to work with data in the form of domain-specific objects and properties.

Entity Framework (EF) Core is a lightweight, extensible, and cross-platform version of the Entity Framework data access technology.Entity framework supports various database provider including Microsoft SQL Server, SQLite, PostgreSQL, MySQL. We can use EFC2 in Full .Net Application, UWP, and .Net Core.

Through this series we will learn how to handle CRUD operations, Code First & Data First Approaches, Migration & Seeding, and Advance Data, Entity, Model concepts.

Along with this we will also see how to send request from PCM & dotnet ef commands.

We will learn all above things through this video series. If you have any doubts then you can contact me via mail and Q & A.

Who this course is for:

This is for newbies who want to learn Entity Framework Core 2.0
Newbies for Object/Relational Mapping (ORM)
Perform operations on MS SQL Server using EFC2

Course Content

Introduction

3 Lectures 00:12:27
- What is Entity Framework Core
  
  Preview
  
  00:02:58
- Development Approaches
  
  Preview
  
  00:03:05
- Setting up Environment for Entity Core
  
  Preview
  
  00:06:24
Code First Approach

2 Lectures 00:15:11
- Create First Model & Create Context
  
  00:07:58
- Use Dependancy & Create DB
  
  00:07:13
CRUD Operations

4 Lectures 00:34:38
- Create - Insert Data into Database
  
  00:08:58
- Read- Retrive Data into Database
  
  00:11:17
- Update - Update Record to Database
  
  00:09:17
- Delete - Delete Record from Database
  
  00:05:06
Data First Approach

2 Lectures 00:12:48
- Assignment
  
  00:00:51
- Database First Approach
  
  00:11:57
Advance Data Operations

4 Lectures 00:42:27
- Sort & Filter Data
  
  00:12:31
- Entity State & Attach
  
  00:13:36
- Native SQL Statements
  
  00:09:23
- Using Store Prodedure
  
  00:06:57
Migrate & Seed

3 Lectures 00:25:09
- Migration - 1
  
  00:08:28
- Migration - 2
  
  00:11:45
- Seed Data
  
  Preview
  
  00:04:56
Advance Model Design

5 Lectures 00:30:26
- Data Annotation - 1
  
  00:07:37
- Data Annotation - 2
  
  00:06:56
- Modify Column name & type
  
  00:03:40
- Modify Table Name
  
  00:03:46
- ModelBuilder
  
  00:08:27
What is New in 2.0

5 Lectures 00:29:24
- HasQueryFilter ()
  
  00:09:35
- EF.CompileQuery()
  
  00:06:32
- EF.Function()
  
  00:03:52
- String interpolation
  
  00:04:37
- OwnOne()
  
  00:04:48
Advance Entity concepts

3 Lectures 00:22:45
- Concurrency
  
  00:10:58
- Manage Transactions
  
  00:04:42
- Manage Logs
  
  00:07:05
More On

2 Lectures 00:04:16
- Conclusion
  
  00:02:47
- Bonus Lecture
  
  00:01:29

Nilay Mehta

Passionate Software Engineer and Instructor

Hey, My name is Nilay Mehta! I am an experienced .Net developer, having the Microsoft certificate of Programming with C#.Net. I have a Master of Computer Applications and Bachelor of Computer Application degrees. Starting out in the IT industry about 3 years ago. I've worked with a range of development tools from PHP, C#, ASP.NET, and ASP.Net core. I am a passionate software engineer who loves learning new technologies, and from the past 3 years, I'm enjoying sharing that knowledge through blogs and courses.