ADO.NET BY ANIL KUMAR

         ADO.NET (ACTIVE X DATA OBJECT)

 TO DO THE CONNECTIVITY BETWEEN .NET APPLICATION AND YOUR DATABASE SQL SERVER OR ANY ANOTHER DATABASE

       

                 .NET APPLICATION                                                                                               SQL SERVER

                                                                                                                                                        DATABASE

 

                                                                                               ADO.NET                                      MS ACESS

Ø SQL CONNECTION AND COMMAND ARE DATABASE DEPENDENT

       PROVIDERS

Ø   ODBC

    

          ODBC IS THE TECHNIQUE OF MICROSOFT(OPEN DATABASE CONNECTIVITY)

 IN WHICH WE CAN WRITE DATABASE INDEPENDECE CODE.    ODBC IS THE COLLECTION OF INTERFACES

                                 IF WE CALL THE ODBC IN OUR APPLICATION THAN WE CAN CONNECT TO DIFFERENT DATABASE

Ø ODBC DRIVERS MANAGERS INSTALLED AUTOMATICLLY WHEN WE INSTALLED OUR DATABASE.

Ø ODBC IS THE ADVANCED VERSION OF OLEDB

Ø IT WAS DEPENDENT ON COM(COMPONENET OBJECT MODEL) TECHNIQUE

Ø DAO(DATABASE ACCESS OBJECT) IS THE FIRST DATABASE MODEL AND NOT SUPPORT THE CLIENT SERVER ARCHITECTURE

Ø  OLEDB PROVIDER

Ø SQL PROVIDER

Ø ORACLE PROVIDER

                                     DIFFERENCE BETWEEN CONNECTED AND DISCONNECTED MODE

C ONNECTED MODE

DISCONNECTED MODE

                       

                              DAO

                         (DATABASE ACCESS OBJECT)                                     RDO

                                                                                                      (REMOTE DATA OBJECT)

 

                                                                                                                

                                                                                                                 ADO                                      ADO.NET

 

Ø HERE RDO DOES NOT SUPPORT CLINET SERVER ARCHITECTURE)

                                  DIFFERENCE BETWEEN ADO AND ADO.NET  

                     ADO                                                                            ADO.NET

IT SUPPORT ONLY CONNECTED ARCHITECTURE	IT SUPPORT BOTH CONNECTED AND DISCONNECTED ARCHITECTURE
RECORD SET PLAY AN IMPORTANT ROLE IN MEMORY OBJECT	HERE DATASET PLAY AN IMPORTANT ROLE IN MEMORY OBJECT
IN SINGLE RECORD SET YOU CAN HOLD ONLY  SINGLE RESERVE SET	WE CAN MANAGE COLLECTION OF TABLES OR DATA TABLE
HERE WE WORK ON REAL DATA	HERE WE DON’T WORK ON REAL DATA, HERE WE WORK ON VIRTUAL DATA
IT IS FASTEST IN DATA ACCESS	IT IS SLOWER THAN ADO
HERE WE CAN’T MANAGE THE RELATIONSHIP	HERE WE CAN MANAGAE THE RELATIONSHIP
CONSTRAINTS IMPLEMENTATION IS NOT POSSIBLE IN RECORD SET	CONSTRAINTS IMPLEMENTATION IS POSSIBLE IN DATA SET
XML INTEGRATION IN ADO IS VERY POOR	XML INTEGRATIN IS VERY POWERFULL IN ADO.NET
ODBC AND OLEDB ARE UNIVERSAL PROVIDERS ( IT HAS ONLY TWO PROVIDERS)	SQL CLIENT, ORACLE CLIENT, OLEDB AND ODBC HERE WE HAVE FOUR PROVIDERS

     

COMPONENTS OF PROVIDERS

 THERE ARE FIVE COMPONENTS OF PROVIDERS

1.    CONNECTION

2.    COMMAND

3.    DATA READER

4.    DATA ADAPTOR

5.    COMMAND BUILDER

  NAMESPACE

TO BE ADD TO USE CLASSES TO DO CONNECTIVITY

1.    SQL CLIENT                        USING  SYSTEM.DATA.SQLCIENT;

2.    ORACLE CLIENT                USING  SYSTEM.DATA.ORACLECIENT;

3.    OLEDB CLIENT                USING  SYSTEM.DATA.OLEDB;

4.    ODBC CLIENT                USING  SYSTEM.DATA.ODBC;

 

CONNECTION

  TO MAINTAIN THE PHYSICAL CONNECTION WITH THE DATABASE.

DATA ADAPTOR

     DATA ADAPTOR IS AUTOMATIC CONNECTED OR DISCONNECTED CONNECTION MEANS OPEN AND CLOSE THE CONNECTION AUTOMATICALLY.

                                                                                                       DATA ADAPTOR IS A CLASS WHICH CAN CHANGE THE LOCAL DATA, UPDATE DATA INTO THE OBJECT AND DATABASE SERVER.

·       DATA ADAPTOR ACT AS A BRIDGE BETWEEN DATABASE AND DATASET.

   APPLICATION                                          ADO.NET

 

                                                                                                                                                                                                                    SQL SERVER                                    

                                                                             DATA ADAPTOR

      DATA SET

     

 

     TABLE1

                                                                                                            COLLECTION OF DATA TABLES

                                                                                                     DATA ROW

                                                                                                                                                         DATA COLUMNS

   COMMAND BUILDER

       SQL COMMAND BUILDER IS USED IN DISCONNECTED ARCHITECTURE, IT IS USED TO BUILD COMMANDS ACCORDING TO THE CHANGE IN TABLE DONE BY THE USER AT FRONT END AND GIVE THEM TO DATA ADAPTOR

1.    OLEDB COMMAND BUILDER

2.     SQL COMMAN BUILDER

DATA SET

     

          DATASET IS THE COLLECTION OF OBJECT OF DATA TABLES./ AND DATA TABLES KEEPS THE DATA IN FORM OF DATACOLUMN AND DATA ROW

        DATA SET PLAY AN IMPORTANT ROLE TO HOLD THE DATA OF MORE THAN ONE TABLES OR OF ONE TABLE IN DISCONNECTED ARCHITECTURE

DATA TABLE

  DATA TABLE IS A CLASS WHICH UNDERSTAND THE STRUCTURE OF DATA COLUMNS AND DATA ROWS.

WHEN WE CALL THE FILL COMMAND IT ALWAYS EXECUTE THE SELECT COMMAND.

PROCESS BEHIND THE FILL COMMAND

     THERE ARE ALL WORKS BEHIND WHEN WE CALL THE FILL COMMAND

• CREATE CONNECTION
• OPEN CONNECTION
• COMMAND EXECUTION
• TO KEEP THE RESERVE SET
• CREATE THE OBJECT OF DATATABLE
• STORE THE RESERVE SET IN TO DATA TABLE.
• CLOSE CONNECTION

  

DATA READER

  DATA READER IS USED TO READ DATA ONLY, READ ONLY ONE ROW, AND USED IN CONNECTED ARCHITECTURE