What you'll learn?

·Describe ADO.Net Architecture and Object Model

·Connect to SQL and other data sources

·Perform connected database operations

·Perform disconnected database operations

·Implement transactions

·Perform operations by Data Entity Model

Description

This course provides a comprehensive introduction to ADO.NET 4.5. It is intended to qualify trainees to build desktop database application using Visual C# 2012. However, the information and skills acquired in this course could be easily utilized to create other types of applications that connect to a database or other data sources.

Audience :

This course is essential for trainees aspiring to build database applications.

Topics :

Introduction to ADO.NET

·          What is ADO.NET?

·          ADO.NET and the .NET Framework

·          ADO.NET components

·          .NET Framework Data Providers

·          ADO.NET object model

·          Connected scenario

·          Disconnected scenario

Working with Data Sources - Connected scenario

·         Preparing connections by using SQLConnection Class

·         Querying data by using SQLDatareader Class

·         Making data modifications by using SQLCommnd Class

·         Controlling concurrency transactions by using SQLTransaction Class

Working with Data Sources - Disconnected scenario

·         Working with DataSet Class

·         Creating DataColumns, DataRows, Data relations in DataSet Class

·         Working With DataAdapter

·         Filtring data by using databinding, DataView .

·         Binding Data Controls

Working with Data Sources - Data Entity Model

·         Retrieving data by using Linq

Making data modification using DEM.

Prerequisities :

Recommended Knowledge :

This course requires having basic skills of object-oriented programming concepts, SQL Server 2008 or later , .NET Framework 3.5 or later and Visual C# 2010 or later.

Recommended Course(s) :

Category :

  • Programming
  • Software Development

Training Materials :

YAT Official Courseware

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is an essential part of YAT Professional Diploma in Programming: Visual Studio 2012