DataReader Class

A DataReader object allows forward-only, read-only access to a database. Different properties and strategies for the Command classes are saved for later exercises. Each provider has its own version of DataReader which inherits the System.Data.Common.DbDataReader base class. Provider…

Command Class

Each data provider has their Command class which is used to execute SQL commands or stored procedures to the database. Each Command class inherits from the System.Data.Common.DbCommand base class. The following are the different…

Connection Class

Each data provider in ADO.NET contains a Connection class that inherits from the System.Data.Common.DbConnection  class. The DbConnection serves as the base class for all the Connection classes of different data providers. The following are the connection categories…

Data Providers

A data provider is a set of classes the manages and handles the connection to a data source such as SQL Server. The .NET Framework provides you with different data…

Connection Strings

A connection string may be a series of name/value pairs separated by punctuation that indicate the settings for connecting to a database. Such settings embody the situation of the database,…

SQL Basics

Before you deal with accessing and modifying databases, you first need to know the basics of SQL (Structured Query Language). This is the language used for querying databases. SQL is…

Databases and ADO.NET

Most of the applications today uses some sort of data storage. Perhaps the only applications I can imagine that doesn't use some kind of storage for its data are those…