ADO.Net Interview Question and Answers

61. What is Data Provider?
  A set of libraries that is used to communicate with data source. Eg: SQL data provider for SQL, Oracle data provider for Oracle, OLE DB data provider for access, excel or mysql.
The data providers refers to a collection of objects that is responsible for providing and maintaining the connection to a database.
 
Your Name Your Email-ID
Your Answer
62. What is the provider and namespaces being used to access oracle database?
  system.data.oledb
 
Your Name Your Email-ID
Your Answer
63. Which object is used to add a relationship between Data table objects?
  The DataRelation object is used to add a relationship between Data table objects.
 
Your Name Your Email-ID
Your Answer
64. What are the benefits of LINQ?
 
  • LINQ is available in all .NET platform language such as C#.NET, VB.NET and F#.NET.
  • Easily transforms data into objects and vice versa.
  • Reduce SQL injection attacks, hence is more secure.
  • It makes it easier to extra data from several data sources(XML, SQL, Objects etc).
  • Reduces the code size as it provides relatively short codes for queries.
 
Your Name Your Email-ID
Your Answer
65. What is the use of System.Data namespace in ADO.Net?
  System.Data:
This contains the basic objects used for accessing and storing relational data such as dataset,datatable and data relation.
 
Your Name Your Email-ID
Your Answer
123456789101112


13141516 Page 13 of 16