Skip to content

Latest commit

 

History

History
174 lines (132 loc) · 7.31 KB

README.md

File metadata and controls

174 lines (132 loc) · 7.31 KB
Raw

Entity Framework Core

The course "Entity Framework Core" follows in detail the work with the ORM technology: Entity Framework Core (EF core), which is a standard for ORM in C# and .NET Core applications. EF Core enables mapping between a relational database and an object-oriented model through "database first" and "code first" approaches, and provides a powerful object-oriented API for querying the database and performing CRUD operations. EF core provides both an additional level of abstraction and an easy way to process the data from the database. In the course, we will demonstrate established practices in building the database layer of complex systems in C# applications through built-in implementations of the Repository pattern and the use of the service layer (Service Layer), as well as import and export to various data formats (JSON, XML).

 

Topics:

  • ADO.NET
  • ORM Fundamentals
  • LINQ
  • Entity Relations
  • Advanced Quering
  • C# Auto Mapping Objects - AutoMapper
  • JavaScript Object Notation - JSON Processing
  • Extensible Markup Language - XML Processing
  • Workshops - ASP.NET MVC
  • Best Practices and Architecture

Acquired skills:

  • Building a database architecture
  • Using the Code First approach
  • Using the Database First approach
  • Retrieve data using LINQ queries
  • Working with a database using an ORM
  • Work with different data formats - XML, JSON

  Certificate(Click here to preview)  

SoftUni Judge Solved Tasks

 

Entity Framework Introduction

Exercises
1 Database First
2 Employees Full Information
3 Employees With Salary Over 50000
4 Employees from RnD
5 Adding new address and updating employee
6 Employees and Projects
7 Addresses By Town
8 Employee 147
9 Departments with More than 5 employees
10 Find latest 10 projects
11 Increase Salaries
12 Find Employees by First Name Starting With Sa
13 Delete Project By Id
14 Remove Town

 

Entity Relations

Exercises
1 Student System
2 Football Betting

 

LINQ (Language-Integrated Query)

Exercises
1 Music Hub

 

Advanced Quering

Exercises
1 Age Restriction
2 Golden Books
3 Books by Price
4 Not Released In
5 Book Titles By Category
6 Released Before Date
7 Author Search
8 Book Search
9 Book Search by Author
10 Count Books
11 Total Book Copies
12 Profit by Category
13 Most Recent Books
14 Increase Prices
15 Remove Books

 

JavaScript Object Notation - JSON

Exercises
1 Product Shop
2 Car Dealer

 

Extensible Markup Language - XML

Exercises
1 Product Shop
2 Car Dealer

 

Workshops - ASP.NET MVC

Projects
1 Eventmi
2 Blog

 

Back top top