ADO.Net Overview

First of all i would like to tell u the database basic so that you can start using ado.net in your applications...

What is Database?
            "The database is the collection records or the data for permenant  storage so that only useful/meaningful  information can be stored".
             Before going further you should know the difference between the data and the information. so what is the actual difference between them..?

 Data:

It is the collection of useful  information as well as the information that is not useful but need to store.  I mean  it is the raw data without  any  reference .

Information:
  It is all the uefull information which has meaning. means it is the filtered from the data and now has a value.

for eg: suppose 10 mobile number is given to you but you dont know the corresponding names that it refers then it has no value. so that becomes your data and suppose i tell the name regarding the mobile numbers with reference then it becomes useful information so that you can contact them by their respective name. Now i think you people got the difference between data and information. Now its time to move further with our topic

Types Of Databases:
        There are two types of databases :-
1. ISAM (Index Sequential Access Database)
   example: ms-access,exel,flat files
2. VSAM(Virtual Sequential Access Database)
  example:sql server,my-sql,oracal etc.

Scenario Before Ado.Net:- 

Observation:

 DAO: It is  an object model specially designed for interacting with databases(ISAM).

Limitation: It doesnt understand the networks and hence it cant be used for VSAM and limited only to standalone applications.

RDO: It is an object model designed specially for VSAM using dsn(data source name) for interacting with odbc drivers for connecting to any database.

Limitation: It ises network concept so if we use it for interacting with ISAM them performance will slow and hence it uses odbc driver and it is tightly coupled with operating systems will create issues.

ADO: It is a special object model which uses COM for interacting with databases.

Limitation: All limitation of com object model will be applicable to ado

Now in next post i will be explaining you about the ADO.Net....Wait for post