ADO.NET - DotNet Programming Interview Questions and Answers | LucentBlackBoard

Home > Technical Interviews > Computer Science & Engineering > DotNet Programming > ADO.NET Questions and Answers

11.	Mention the namespace that is used to include .NET Data Provider for SQL server in .NET code.
	The System.Data.SqlClient namespace.

12.	What is the difference between OLEDB Provider and SqlClient?
	With respect to usage, there is no difference between OLEDB Provider and SqlClient. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for various databases, such as Oracle and Access including SQL Server. Therefore, there will be an overhead which leads to performance degradation.

13.

Name the two properties of the GridView control that have to be specified to turn on sorting and paging.

The properties of the GridView control that need to be specified to turn on sorting and paging are as follows:
• The AllowSorting property of the Gridview control indicates whether sorting is enabled or not. You should set the AllowSorting property to True to enable sorting.
• The AllowPaging property of the Gridview control indicates whether paging is enabled or not. You should set the AllowPaging property to True to enable paging.

14.

Mention different types of data providers available in .NET Framework.

• .NET Framework Data Provider for SQL Server - Provides access to Microsoft SQL Server 7.0 or later version. It uses the System.Data.SqlClient namespace.
• .NET Framework Data Provider for OLE DB - Provides access to databases exposed by using OLE DB. It uses the System.Data.OleDb namespace.
• .NET Framework Data Provider for ODBC - Provides access to databases exposed by using ODBC. It uses the System.Data.Odbc namespace.
• .NET Framework Data Provider for Oracle - Provides access to Oracle database 8.1.7 or later versions. It uses the System.Data.OracleClient namespace.

15.	Which architecture does Datasets follow?
	Datasets follow the disconnected data architecture.

Previous 1 2 3 4 5 6 Next

LucentBlackBoard.com has the web's largest collection of over 15,000 aptitude questions and answers with detailed explanation which include subjects like Arithmetic Aptitude, Logical Reasoning, Verbal Ability, General Knowledge, Programming Skills and more!

Our online education portal provides a unique and standard learning experience for students. We enable the students to prepare for most of the entrance and competitive exams like MBA (MAT, GMAT), Engineering (IIT-JEE, AIEEE, GATE), Employment (IAS, Bank PO, Railway, UGCNET), Civil Services and many more. We bring you the best in education by providing technical excellence and creating innovative solutions. We provide facility for online test preparation that offers 24/7 access to relevant subject matter and relative tests. These test preparations help the students to groom themselves and get prepared before actually facing the examination.