Design, query, and manage data architectures using ADO.NET, Entity Framework, LINQ, and REST services
The nature of current applications heavily relies on data in various forms (database server, XML, JSON, etc.). In addition to traditional skills required for application development, developers must now master the ADO components of the .Net Framework to ensure quality data access. Through the implementation of design patterns such as MVC or MVVM, data access aims to detach itself from databases and often involves object-relational mapping, which has been addressed by the introduction of Entity Framework.
Is it for you ?
Developers, developers of computer applications
Prerequisites
• Have attended the "C# Programming with .Net 5" (MS860) training or master the object-oriented programming language C#
• Knowledge of relational database concepts and SQL language
What You'll Walk Away With
- ✓ Design data access architectures (client-server, n-tier, SOA) for robust .NET applications
- ✓ Use ADO.NET in connected and disconnected modes to improve data performance and handling
- ✓ Implement object-relational mapping with Entity Framework (Database First, Code First)
- ✓ Query and manipulate data efficiently using LINQ (Objects, XML, Entities)
- ✓ Build interoperable web services (WCF, REST, Web API) to expose and consume data effectively
Training content
1 ARCHITECTURE OF DATA-RELATED APPLICATIONS
- Client-Server Architecture
- n-Tier Architecture
- Service-Oriented Architecture
- .Net Data Access Technologies
2 ADO .NET
- System.Data and data access providers
- Connected architecture and DbDataReader
- Disconnected architecture and DbDataAdapter
- DataSet: typing, serialization
3 ENTITY FRAMEWORK
- Object-relational mapping significance
- EDMX: Database First, Model First
- Entity Framework 7 and Code First approach
- The context object
4 LINQ
- Extension methods, delegates, and Lambda expressions
- LINQ To Objects
- LINQ To XML
- LINQ To Entities
5 UPDATING DATA THROUGH ENTITY FRAMEWORK
- Insertion, modification, and deletion
- Multi-user scenario
6 SERVICE-ORIENTED ARCHITECTURES FOR WEB APPLICATIONS
- Different types of services
- WCF services
- Cloud services
7 INTEROPERABLE REST SERVICES
- Advantages of the REST approach for Front-end consumption
- WCF data services
- Web API services.
Keep in Mind
This training is eligible for the Atlas collective action "Develop with .Net, Java, and C++ languages" (Ref: 28109).
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
