A quick look at Database Technologies provided by Mircosoft


                     To access data from database like SQL server and oracle, .net framework provides ADO.Net. when we look at database technologies provided by Microsoft, they are as follows.

Database Technology 

 Description

 DAO
(Data Access Objects)
  •  This works based on JetEngine or DBEngine.
  •  It is efficient in accessing desktop databases
    like MS Access, Foxpro and Excel.
  • It   is   not   efficient   in   accessing   remote
    databases like SQL Server and Oracle.
 RDO
(Remote Data Objects)
  • This works based on ODBC(Open DatabaseConnectivity).
  • It is efficient in accessing remote databases.
  •  It can  not  access  the databases  that  don’t support ODBC.
 ADO
(Activex Data Objects)
  • This works based on OLEDB (Object Linking and Embedding DataBase).
  • It can access almost any database that may be desktop database or remote database and that may support ODBC or may not support ODBC.
  • It is efficient than DAO and RDO.
  • It doesn’t support pure architecture.
  • It doesn’t support XML.
 ADO.Net
  •  To   overcome   the drawbacks of  ADO,   in   .net, Microsoft provides ADO.Net.
  • Same as ADO it can access almost any database that may be desktop database or remote database and that may support ODBC or may not support ODBC.
  • It supports pure disconnected architecture and XML.