ADO.Net Interview Question and Answers

46. Which architecture does datasets follow?
  Datasets follows the disconnected data architecture.
 
Your Name Your Email-ID
Your Answer
47. What is Serialization?
 
  • Serialization is the process of persisting the state of an object after converting it into a stream of bytes.
  • The object can be persisted to a file, a database or memory.
 
Your Name Your Email-ID
Your Answer
48. What is Execute Non Query?
  The ExecuteNonQuery() is one of the most frequently used method in SqlCommand Object, and is used for executing statements that do not return result sets (ie. statements like insert data , update data etc.).
 
Your Name Your Email-ID
Your Answer
49. What providers does Ado.net uses?
  The .NET Framework provides mainly three data providers, they are
  • Microsoft SQL Server,
  • OLEDB,
  • ODBC.
 
Your Name Your Email-ID
Your Answer
50. How will you close the Database Conenction?
  Always close both the DataReader and database connection after access to the database is no longer required.
  • dbread.Close()
  • dbconn.Close()
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 10 of 16