ABOUT THE COURSE We will look in detail at working with a modern ORM technology: Entity Framework (EF), which is a standard ORM standard in C # and .NET applications. EF allows mapping between a relational base and object-oriented model using the "database first" and "code first" approaches and provides a powerful object-oriented API for querying the database and performing CRUD operations. We will demonstrate established practices in building a database layer on sophisticated systems using the "Repository" and "Unit of Work" templates.

During the course a practical team project will be developed that includes practical use of different DB servers (SQL Server, MySQL), data access platforms and technologies (ADO.NET, Entity Framework, etc.) and import and export to various formats for data (JSON, XML).

The course is part of the overall program with C # courses and tutorials for the "C # programmer" training at the University of Software.

SKILLS WHICH YOU WILL ACQUIRE

• Design of a database design
  
• Using approaches to create Code First and Database First
  
• Working with a database using ORM work frames
  
• Working with different data formats - XML, JSON
  

1. RESOURCES
2. COURSE INTRODUCTION
   
3. DEFINING CLASSES - LAB
   3.1. DEFINING CLASSES - EXERCISE
   
4. ENCAPSULATION AND VALIDATION - LAB
   4.1. ENCAPSULATION AND VALIDATION - EXERCISE
   
5. INHERITANCE AND GENERICS - LAB
   5.1. INHERITANCE AND GENERICS - EXERCISE
   
6. C# OOP INTRO EXERCISE
   
7. DB APPS INTRODUCTION
8. EXERCISE: FETCHING RESULTSETS WITH ADO.NET
9. INTRODUCTION TO ENTITYFRAMEWORK
10. EXERCISE: INTRODUCTION TO ENTITYFRAMEWORK
    
11. CODE-FIRST
12. EXERCISE: CODE-FIRST
    
13. ENTITY RELATIONS
14. EXERCISE: ENTITY RELATIONS
    
15. ADVANCED RELATIONS AND AGGREGATION
16. EXERCISE: ADVANCED RELATIONS
    
17. ADVANCED QUERYING
18. EXERCISE: ADVANCED QUERYING
    
19. BEST PRACTICES AND ARCHITECTURE
20. EXERCISE: BEST PRACTICES AND ARCHITECTURE
21. C# AUTO MAPPING OBJECTS
22. EXERCISE: AUTO MAPPING OBJECTS
23. EXTERNAL FORMAT PROCESSING
    
24. EXERCISE: EXTERNAL FORMAT PROCESSING
25. WORKSHOP
26. EXAM PREPARATION
27. EXAM PREPARATION
28. OPEN CONSULTATION
29. OPEN CONSULTATION
30. PRACTICAL EXAM