-
Database Access
Can we do database operations without using any of the ADO.net objects?This was an interview question
Read Best Answer
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.aspx2. 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!
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.
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.aspx2. A...
