Software University
Databases Advanced - Entity Framework - октомври 2017
За курса
Курсът проследява в детайли работата с ORM технологията: Entity Framework Core (EF core), която е стандарт за ORM в C# и .NET Core приложения. EF Core позволява mapping между релационна база и обектно-ориентиран модел чрез подходите ""database first"" и ""code first"" и предоставя мощно обектно-ориентирано API за заявки към базата данни и извършване на CRUD операции. Ще демонстрираме утвърдени практики при изграждане на database layer на сложни системи чрез шаблоните ""Repository"" и ""Unit of Work"".
Умения, които ще придобиеш
- Изработване на дизайн на база данни
- Използване на подходи за създаване на база данни Code First и Database First
- Работа с база данни посредством ORM работни рамки
- Работа с различни формати данни - XML, JSON
Теми
- 1 Resources
- 2 Course Introduction
- 1 Resources
-
- 2 Course Introduction
-
- 3 Defining Classes
- 4 Encapsulation and Validation
- 3 Defining Classes
-
- 4 Encapsulation and Validation
-
- 5 Inheritance and Generics
- 6 C# OOP Intro Exercise
- 5 Inheritance and Generics
-
- 6 C# OOP Intro Exercise
-
- 7 DB Apps Introduction
- 8 Exercise: Fetching Resultsets with ADO.NET
- 7 DB Apps Introduction
-
- 8 Exercise: Fetching Resultsets with ADO.NET
-
- 9 Introduction to EntityFramework
- 10 Exercise: Introduction to EntityFramework
- 9 Introduction to EntityFramework
-
- 10 Exercise: Introduction to EntityFramework
-
- 11 Code-First
- 12 Exercise: Code-First
- 11 Code-First
-
- 12 Exercise: Code-First
-
- 13 Entity Relations
- 14 Exercise: Entity Relations
- 13 Entity Relations
-
- 14 Exercise: Entity Relations
-
- 15 Advanced Relations and Aggregation
- 16 Exercise: Advanced Relations
- 15 Advanced Relations and Aggregation
-
- 16 Exercise: Advanced Relations
-
- 17 Advanced Querying
- 18 Exercise: Advanced Querying
- 17 Advanced Querying
-
- 18 Exercise: Advanced Querying
-
- 19 Best Practices and Architecture
- 20 Exercise: Best Practices and Architecture
- 19 Best Practices and Architecture
-
- 20 Exercise: Best Practices and Architecture
-
- 21 C# Auto Mapping Objects
- 22 Exercise: Auto Mapping Objects
- 21 C# Auto Mapping Objects
-
- 22 Exercise: Auto Mapping Objects
-
- 23 External Format Processing
- 24 Exercise: External Format Processing
- 23 External Format Processing
-
- 24 Exercise: External Format Processing
-
- 25 Workshop
- 26 Exam Preparation
- 25 Workshop
-
- 26 Exam Preparation
-
- 27 Exam Preparation
- 28 Open Consultation
- 27 Exam Preparation
-
- 28 Open Consultation
-
- 29 Open Consultation
- 30 Practical Exam
- 29 Open Consultation
-
- 30 Practical Exam
-