TI210
Information technology

Advanced C#: Mastering Data Access with Visual Studio

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.

Objectives

This training precisely provides programmers with the basics of ADO .Net and Entity Framework, enabling them to quickly integrate into projects or development teams using these standards.

Is it for you ?

Developers, developers of computer applications

Prerequisite


• 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

Your benefits

  • 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
  • Content

    ARCHITECTURE OF DATA-RELATED APPLICATIONS

    • Client-Server Architecture
    • n-Tier Architecture
    • Service-Oriented Architecture
    • .Net Data Access Technologies

    ADO .NET

    • System.Data and data access providers
    • Connected architecture and DbDataReader
    • Disconnected architecture and DbDataAdapter
    • DataSet: typing, serialization
    See more + / -

    ENTITY FRAMEWORK

    • Object-relational mapping significance
    • EDMX: Database First, Model First
    • Entity Framework 7 and Code First approach
    • The context object

    LINQ

    • Extension methods, delegates, and Lambda expressions
    • LINQ To Objects
    • LINQ To XML
    • LINQ To Entities

    UPDATING DATA THROUGH ENTITY FRAMEWORK

    • Insertion, modification, and deletion
    • Multi-user scenario

    SERVICE-ORIENTED ARCHITECTURES FOR WEB APPLICATIONS

    • Different types of services
    • WCF services
    • Cloud services

    INTEROPERABLE REST SERVICES

    • Advantages of the REST approach for Front-end consumption
    • WCF data services
    • Web API services.

    Notes

    This training is eligible for the Atlas collective action "Develop with .Net, Java, and C++ languages" (Ref: 28109).

    💡 Useful information

    Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .

    Duration
    4 days
    Schedule
    See training dates for details
    Regular fee
    $2,675
    Preferential fee A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
    $2,400
    Private or personalized training

    Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.

    Request a quote

    Request in-company training

    Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.

    Tell us more
    Added to cart View my cart