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