ADO.NET by Example

This course provides a complete look at ADO.NET Disconnected Model and Connection Oriented Model with multiple demos for understanding ADO.NET for beginners. By the end of the course, even a beginner can develop efficient applications to interact with any database from Windows forms and ASP.NET Web Applications.
Course info
Rating
(182)
Level
Beginner
Updated
Oct 15, 2015
Duration
2h 4m
Table of contents
Introducing ADO.NET
Establishing Connections with the Database
Working with ADO.NET Disconnected Model
Working with Connection Oriented Model
Implementing 3-tier Architecture
Managing Concurrency
Description
Course info
Rating
(182)
Level
Beginner
Updated
Oct 15, 2015
Duration
2h 4m
Description

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#.

About the author
About the author

Sekhar Srinivasan is a Microsoft Certified Trainer with 19 Years experience.

More from the author
Java EE: Java Server Pages
Beginner
3h 44m
Feb 10, 2017
Java EE: Programming Servlets
Beginner
4h 26m
Jul 6, 2016
Section Introduction Transcripts
Section Introduction Transcripts

Establishing Connections with the Database
Hello, this is Sekhar Srinivasan for Pluralsight. In this module, we will understand the importance of connection string, how to generate the connection string to various databases with the support of UDL, and also we will understand how to download the backup and restore the database, which we may use in other modules. And also, we shall understand how to use connection string and establish connections to the database with the support of simple demo. Now, let's get started.

Working with Connection Oriented Model
Hello, this is Sekhar Srinivasan for Pluralsight. In this module, we shall understand the connection-oriented model in detail with various examples. This module explains how to perform CRUD operations using connection-oriented model, how to create stored procedures, and consume the stored procedures. This module also explains the need of bulk copying and how to achieve bulk copying using SQLBulkCopy command. We shall also understand how to store and retrieve images from the database. And this module will also discuss about the importance of connection pooling and how to achieve connection pooling. Now, let us understand how to work with connection-oriented model.

Managing Concurrency
Hello. This is Sekhar Srinivasan for Pluralsight. In this module, we will understand what is data concurrency, type of concurrency controls, and how to perform optimistic concurrency control with an example. Now, let us understand what data concurrency is.