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.
Vithal WadjePosted Oct 20, 2012, 5:34 AM
ok sir,thank you
Mahesh ChandPosted Oct 20, 2012, 2:38 AM
You can learn more about ODBC and ODBC .NET here http://www.c-sharpcorner.com/UploadFile/mahesh/ODBCDataProvider112032005073350AM/ODBCDataProvider1.aspx
Mahesh ChandPosted Oct 20, 2012, 2:38 AM
You can learn more about ODBC and ODBC .NET here http://www.c-sharpcorner.com/UploadFile/mahesh/ODBCDataProvider112032005073350AM/ODBCDataProvider1.aspx
Vithal WadjePosted Oct 20, 2012, 12:35 AM
mahesh sir, just i have forgeted to write one line that is "Because of the all above drawbacks of database technologies,the ado.net is used in dot net framework". if have read my blog i have expalined the drawback of each other database technologies. but mahesh sir i promise you that in future i will take care of this thank you
Mahesh ChandPosted Oct 19, 2012, 10:32 AM
You missed one of the most used, ODBC. You really don't need DAO and ADO if you are working with .NET framework. ODBC and ADO.NET are sufficient.
Vithal WadjePosted Oct 19, 2012, 8:33 AM
ok sir
Shivanand ArurPosted Oct 19, 2012, 8:23 AM
Absolutely Vithal... Good one :)
Vithal WadjePosted Oct 19, 2012, 8:18 AM
ok sir just i have inspired from all of us,because by reading yours articles and others members. i have realise that just working 8 hours in company and earning money is not a great thing. but sharing our some of the experience to others by spending some time is actually a great thing.
Shivanand ArurPosted Oct 19, 2012, 8:06 AM
No problem Vithal, You are doing a great job!!!
Vithal WadjePosted Oct 19, 2012, 8:01 AM
ok Shivanand sir, i will check it and i will update my blog. thanks sir
Shivanand ArurPosted Oct 19, 2012, 7:58 AM
Hello Vithal, there is one more now in the List... that is the "Entity Framework"... Check on Google... It is really interesting...