Ado. NET's introduction

Namespaces//provides classes and interfaces for use in. NET data access

Name space	Description
System.Data	All data-access generic classes
System.Data.Common	Classes shared by individual data providers
System.Data.EntityClient	Entity Framework Class
System.Data. Linq.sqlclient	LINQ to SQL provider classes
System. Data. Odbc	Classes of ODBC providers
System.Data. Sql	New generic interfaces and classes for SQL Server data access
System.Data.SqlClient	class for SQL Server provider
System.Data.SqlTypes	SQL Server Data type

Database-specific Classes

Class	Description
SqlCommand	Wrapper used as an SQL statement or stored procedure call
SqlCommandBuilder	Used to generate SQL commands from a SELECT statement
SqlConnection	Used to connect to the database
SqlDataAdapter	Class for storing the Select,insert,update,delete command
SqlDataReader	For forward-only connection data readers
SqlParameter	Used to define a parameter for a stored procedure
SqlTransaction	Used for database transactions, wrapped in an object.