Database Technologies provided by Mircosoft

To access data from database like SQL server and oracle, .net framework provides ADO.Net simmilar to this   their are diffrent database technologies provided by microsoft according to the use of requirement which is i have explained below in my blog.

• DAO (Data Access Objects) Database technology

1. This works based on JetEngine or DBEngine.
2. It is efficient in accessing desktop databases  like MS Access, Foxpro and Excel.
3. It is not efficient in accessing remote  databases like SQL Server and Oracle.

• RDO  (Remote Data Objects)  Database technology

1. This works based on ODBC(Open DatabaseConnectivity).
2. It is efficient in accessing remote databases.
3. It can not access the databases that don't support ODBC.

• ADO  (Activex Data Objects)  Database technology

1. This works based on OLEDB (Object Linking and Embedding DataBase).
2. It can access almost any database that may be desktop database or remote database and that may support ODBC or may not support ODBC.
3. It is efficient than DAO and RDO.
4. It doesn't support pure architecture.
5. It doesn't support XML.

• ADO.Net  Database technology

1. To overcome the drawbacks of ADO, in .net, Microsoft provides ADO.Net.
2. 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.
3. It supports pure disconnected architecture and XML.

I hope this blog is useful for readers.