Database Access

Can we do database operations without using any of the ADO.net objects?

This was an interview question

Questions by Lavanyaaru   answers by Lavanyaaru

Editorial / Best Answer

amitdotchauhan  

  • Member Since Jun-2010 | Jun 15th, 2010

Yes.

1. SQLCMD is the utility which supports command line interface to perform SQL operations. Output data in xml file & do opertions!
Refer http://msdn.microsoft.com/en-us/library/ms162773.aspx

2. Alternate way to fetch data is enabling SQL server option which allows to provides data on web in XML format (IDK where it is but yes it was there in SQL 2k). Its data on http so you can read & process it just like a web service but cant perform operations.

I am sure there are other ways too! like

1. Create own database format other then SQL

2. Set up API in other application to fetch/process data in other application & set up custom components to store/process them.

Enjoy!

Showing Answers 1 - 16 of 16 Answers

PawanKum

  • Sep 13th, 2009
 

Yes, we can access database without using ADO.net object. we can use ADODB object and other object like ODBC , OLEDB to access database.

  Was this answer useful?  Yes

rakesh_mwisp

  • Nov 4th, 2009
 

According to me, in .NET Technology database access is done through ADO.NET.

ADO.NET contain the classes to access database. So, in .NET there is no other way to access database other than ADO.NET classes which also contains objects for DAO, RDO.

  Was this answer useful?  Yes

amitdotchauhan

  • Jun 15th, 2010
 

Yes.

1. SQLCMD is the utility which supports command line interface to perform SQL operations. Output data in xml file & do opertions!
Refer http://msdn.microsoft.com/en-us/library/ms162773.aspx

2. Alternate way to fetch data is enabling SQL server option which allows to provides data on web in XML format (IDK where it is but yes it was there in SQL 2k). Its data on http so you can read & process it just like a web service but cant perform operations.

I am sure there are other ways too! like

1. Create own database format other then SQL

2. Set up API in other application to fetch/process data in other application & set up custom components to store/process them.

Enjoy!

  Was this answer useful?  Yes

abhisuch

  • Sep 29th, 2010
 

Accessing data from a database is called as database access. We can access data from database using several techniques such as DAO RDO ADO.NET etc.
 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions