Description

This training will allow you to familiarize yourself with the different data access techniques available in .NET. Standard scenarios will be presented through practical workshops, carried out in C# or VB.NET, in the context of Windows Forms, WPF and Web applications.

Who is this training for ?

Developers who want to discover ADO.NET and associated techniques with concrete examples to develop professional applications based on the .NET framework.

Training objectives

Training program

• Introduction
  • Philosophy and architecture of ADOs.
  • NET.
  • Principle of managed data access providers.
  • Organization of classes and namespaces.
  • Application architecture model in three layers.
  • Principle of DataBinding in Windows Forms, WPF and Web.
  • The different uses of XML in ADO.
  • NET.
  • Practical work Data binding of a property of a visual control on an object in Windows and Web.
• Programming with ADO.NET objects
  • Managing a connection (configuration, pooling,.
  • .
  • ).
  • Configuring and executing a command.
  • Reading data with a DataReader.
  • Untyped/typed DataSet.
  • Generic data access techniques.
  • Work practices Program with ADO.
  • NET (Connection, Command and DataReader objects) and create a generic data access class.
• Introduction to LINQ
  • Philosophy and architecture of LINQ.
  • MRO (Object Relational Mapping).
  • Programming techniques: anonymous types, extension methods and lambda expressions.
  • LINQ To Objects (query operators).
  • Manipulate XML (creation and query) with LINQ To XML.
  • Practical work Query a collection of objects and manipulate an XML file.
• LINQ To SQL
  • Overview of advantages and limitations.
  • Using the Object Relational Designer, with configuration of stored procedures.
  • Insert, Update, Delete operations.
  • Resolution of conflicts linked to concurrency access.
  • Practical work Data manipulation on a SQL Server database.
• Entity Framework
  • Presentation: architecture, functionalities, mapping.
  • Design, configuration and diagram of the data model.
  • "Domain Driven Development" approach with generation of the base from the model.
  • Query operations (LINQ to Entities and Entity SQL) and data updating.
  • Using functions and stored procedures.
  • Customize the model: associations, projections, type inheritance, manipulation of object graphs.
  • Exception and concurrency management.
  • Presentation of the REST architecture and implementation of ADO data services.
  • NET.
  • Practical work rnExamples of configuring the entity model, with data manipulation.
  • Consuming a WCF service.