ADO.Net Interview Question and Answers

31. What is the difference between SqlCommand and SqlCommandBuilder?
  SQLCommand is used to retrieve or update the data from database.
SQLCommandBuilder object is used to build & execute SQL (DML) queries like select insert update& delete.
 
Your Name Your Email-ID
Your Answer
32. What is the use of SqlCommandBuilder?
  SQL CommandBuilder object is used to build & execute SQL (DML) queries like select insert update& delete.
 
Your Name Your Email-ID
Your Answer
33. How to copy the database from one server to another server?
  The easiest way to copy a database from one server to another is to back up the database from the source server in the form of SQL script and execute the SQL script on the destination server to recreate database and its respective tables.
 
Your Name Your Email-ID
Your Answer
34. What is LINQ?
 
  • LINQ is an acronym for the Language Integrated Query and is a part of .NET framework.
  • It defines a set of Standard Query Operators that enables us to query data in .NET supported languages.
 
Your Name Your Email-ID
Your Answer
35. Explain ADO.Net Architecture?
 
    ADO.NET provides the efficient way to manipulate the database. It contains the following major components. 1. DataSet Object 2. Data Providers :
  • Connection Object
  • Command Object
  • DataReader Object
  • DataAdapter Object.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 7 of 16