2015
Pluralsight
Sekhar Srinivas
2:04
English
This course is targeted to beginners and will increase their understanding of ADO.NET and its use for interacting with any database or XML documents in an efficient and easy methodology. This course begins with a complete overview of ADO.NET Architecture, both Disconnected Model and Connection Oriented Mode, and subsequent modules will provide complete demos on ADO.NET Disconnected Model, Connection Oriented Model, Implementing 3-Tier Arch, Transaction Management, Concurrency Management, and also deals with performance issues. All demos will be developed using Visual Studio using C#.
Introducing ADO.NET
Introduction
ADO.NET Disconnected Model
Connection
Data Adapter
Dataset
Dataview
Connection Oriented Model
Command
Data Reader
ADO.NET Overview
Summary
Establishing Connections with the Database
Introduction
Understanding the Importance of Connection String
Backup & Restore
Generating Connection String Using UDL
Demo: Establish a Connection with the Database
Summary
Working with ADO.NET Disconnected Model
Introduction
Inserting a Record
Retrieving the Data
Finding the Datarow
Updating a Record
Removing a Record
Reading Data from Excel Sheets
Reading Data from XML Documents
Demo: Generating a Typed Dataset
Demo: Using Typed DataSet
Understanding Data Relations
Demo: Creating Master-details Applications Using Code
Demo: Creating Master-details Applications Using Typed Dataset
Finding the Record Using Dataview
Filtering the Data Using Dataview
Summary
Working with Connection Oriented Model
Introduction
Steps to Work with Connection Oriented Model
Performing CRUD Operations Using Connection Oriented Model
Consuming Stored Procedures
SQLBulkCopy
Storing Images within the Database
Retrieving Images from the Database
Understanding Connection Pooling
Summary
Implementing 3-tier Architecture
Introduction
Understanding Transaction Management
To Do: Implementing 3-tier Architecture
Creating the Class Library
Creating a Windows Forms Application to Consume the Class Library
Registering the Class Library with the GAC
Consuming the Class Library from ASP.NET Web Site
Summary
Managing Concurrency
Introduction
Understanding Data Concurrency
Demo: Implementing Concurrency Control
Summary
Download File Size:254.01 MB
|
