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
- 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)
Database technology
- 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)
Database technology
- 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
Database technology
- 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.
I hope this blog is useful for readers.