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
- RESOURCES
- COURSE INTRODUCTION
- DEFINING CLASSES - LAB
3.1. DEFINING CLASSES - EXERCISE - ENCAPSULATION AND VALIDATION - LAB
4.1. ENCAPSULATION AND VALIDATION - EXERCISE - INHERITANCE AND GENERICS - LAB
5.1. INHERITANCE AND GENERICS - EXERCISE - C# OOP INTRO EXERCISE
- DB APPS INTRODUCTION
- EXERCISE: FETCHING RESULTSETS WITH ADO.NET
- INTRODUCTION TO ENTITYFRAMEWORK
- EXERCISE: INTRODUCTION TO ENTITYFRAMEWORK
- CODE-FIRST
- EXERCISE: CODE-FIRST
- ENTITY RELATIONS
- EXERCISE: ENTITY RELATIONS
- ADVANCED RELATIONS AND AGGREGATION
- EXERCISE: ADVANCED RELATIONS
- ADVANCED QUERYING
- EXERCISE: ADVANCED QUERYING
- BEST PRACTICES AND ARCHITECTURE
- EXERCISE: BEST PRACTICES AND ARCHITECTURE
- C# AUTO MAPPING OBJECTS
- EXERCISE: AUTO MAPPING OBJECTS
- EXTERNAL FORMAT PROCESSING
- EXERCISE: EXTERNAL FORMAT PROCESSING
- WORKSHOP
- EXAM PREPARATION
- EXAM PREPARATION
- OPEN CONSULTATION
- OPEN CONSULTATION
- PRACTICAL EXAM