- ADO.NET IS THE DATA ACCESS PROGRAMMING MODEL FOR ACCESSING THE DATA STORED IN A DATABASE FORM A .NET APPLICATION.
- THE ADO.NET OBJECT MOREL CONSISTS OF TWO MAIN COMPONENTS, DATA PROVIDER AND DATA SET.
- A DATA PROVIDER IS USED FOR CONNECTING TO A DATABASE, RETRIEVING DATA, STORING THE DATA IN A DATA SET, READING THE RETRIEVED DATA, AND UPDATING THE DATABASE.
- THE VARIOUS TYPES OF DATA PROVIDERS ARE:
- .NET FRAMEWORK DATA PROVIDER FOR SQ L SERVER
- .NET FRAMEWORK DATA PROVIDER FOR OLEDB
- .NET FRAMEWORK DATA PROVIDER FOR ODBC
- .NET FRAMEWORK DATA PROVIDER FOR ORACLE
- THE FOR KEY COMPONENTS OF DATA PROVIDERS ARE:
- CONNECTION
- COMMND
- DATAREADER
- DATAADAPTER
- DATAADAPTER
- THE DATA SET IS MEMORY-BASED RELATIONAL REPRESENTATION OF DATA.
