ADO.NET Fundamentals

 

 

ADO.NET Overview

 

 

 

 

 

 

 

 

 

 

 

 

 

Setting Up Your Environment

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Connect to A Data Source Using ADO.NET

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Setup and Connecting with WinForm

 

 

 

 

SqlConnectionStringBuilder

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Retrieving Data from A Data Source

 

 

 

 

Build SQL Statement

 

 

 

 

 

Implement Data Layer

 

 

 

 

 

 

 

 

 

Design Winform Application

 

 

 

 

 

 

 

 

 

 

 

Store Procedure call via ADO.NET

 

 

 

 

 

 

 

 

 

Inserting, Deleting, Updating Data from A Data Source

 

 

 

 

 

 

Prepare Execute Non Query

 

 

 

 

 

Creating Stored Procedure

 

 

 

 

 

 

 

 

 

 

Inserts With Execute Scalar

 

 

 

 

 

 

 

 

 

 

 

Using Output parameter

 

 

 

 

 

 

 

 

 

 

 

 

Using Return Value parameter

 

 

 

 

 

 

 

 

 

 

 

Delete information from DB via Execute Non Query

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Updates with Execute Non Query

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Understanding Errors with ADO.NET

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Catch SQL Exception Errors

 

 

 

 

 

Note:  Change the Date source which does not exist.

 

 

 

 

 

 

 

 

Use Raise Error

 

 

 

 

 

 

 

 

 

 

 

Using SQL Data Adapter

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Load A Data Table via SQL Adapter

 

 

 

 

 

Bind the Data Table

 

 

 

 

 

 

 

 

 

 

 

Update with SQL Adapter

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Client Side Performance Tracking

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Setup Client Statistics

 

 

 

 

 

 

 

 

Retrieve Statistics

 

 

 

 

 

 

Display All statistics

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Round Trips

 

 

 

 

 

 

 

 

 

Managing Concurrency and Transactions

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Concurrency checkings with WHERE Clause

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Concurrency checking with SQL Adapter

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Concurrency checking with Time Stamp

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SQL Transaction

 

 

 

 

 

 

 

 

 

Transaction Scope

 

 

 

 

 

 

 

Note: If you make different DB server calls in this transaction scope that is called as DTC.

 

 

 

Server Transaction

 

 

 

 

 

 

Connection Pooling

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SQL Server Profiler and Pooling

 

 

 

 

 

 

 

 

 

 

 

 

 

Performance Monitor and Pooling

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Using XML with ADO.NET

 

 

 

 

 

 

 

 

 

Writing XML into DB

 

 

 

 

 

 

 

 

 

 

 

 

Reading XML from DB

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Blogger Labels: Fundamentals,Overview,Environment,Connect,Data,Source,Setup,WinForm,SqlConnectionStringBuilder,Build,Statement,Implement,Layer,Design,Application,Procedure,Prepare,Execute,Query,Inserts,Scalar,Output,parameter,Return,Value,Delete,information,Updates,Errors,Catch,Exception,Note,Change,Date,Raise,Error,Adapter,Load,Table,Bind,Update,Client,Side,Performance,Statistics,Retrieve,Display,Round,Trips,Concurrency,Transactions,WHERE,Clause,Time,Stamp,Transaction,Scope,server,Connection,Profiler,Monitor