INTERVIEW QUESTIONS MICROSOFT ADO.NET 2.0 DETAILS

Question: list all the classes those are used for database connections between sql server and asp.net.

Answer: 1.SqlClientPermission - Enables the .NET Framework Data Provider for SQL Server to help ensure that a user has a security level adequate to access a data source.

2.SqlClientPermissionAttribute - Associates a security action with a custom security attribute.

3. SqlCommand - Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

4.SqlCommandBuilder - Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.

5. SqlConnection - Represents an open connection to a SQL Server database. This class cannot be inherited.

6.SqlDataAdapter - Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.

7.SqlDataReader - Provides a means of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.

8.SqlError - Collects information relevant to a warning or error returned by SQL Server. This class cannot be inherited.

9.SqlErrorCollection - Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.

10.SqlException - The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.

11.SqlInfoMessageEventArgs - Provides data for the InfoMessage event. This class cannot be inherited.

12.SqlParameter - Represents a parameter to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.

13.SqlParameterCollection - Represents a collection of parameters relevant to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.

14.SqlRowUpdatedEventArgs - Provides data for the RowUpdated event. This class cannot be inherited.

15.SqlRowUpdatingEventArgs- Provides data for the RowUpdating event. This class cannot be inherited.

16. SqlTransaction - Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.

1.SqlClientPermission - Enables the .NET Framework Data Provider for SQL Server to help ensure that a user has a security level adequate to access a data source.

2.SqlClientPermissionAttribute - Associates a security action with a custom security attribute.

3. SqlCommand - Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

4.SqlCommandBuilder - Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.

5. SqlConnection - Represents an open connection to a SQL Server database. This class cannot be inherited.

6.SqlDataAdapter - Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited.

7.SqlDataReader - Provides a means of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.

8.SqlError - Collects information relevant to a warning or error returned by SQL Server. This class cannot be inherited.

9.SqlErrorCollection - Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.

10.SqlException - The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.

11.SqlInfoMessageEventArgs - Provides data for the InfoMessage event. This class cannot be inherited.

12.SqlParameter - Represents a parameter to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.

13.SqlParameterCollection - Represents a collection of parameters relevant to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.

14.SqlRowUpdatedEventArgs - Provides data for the RowUpdated event. This class cannot be inherited.

15.SqlRowUpdatingEventArgs- Provides data for the RowUpdating event. This class cannot be inherited.

16. SqlTransaction - Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question