Microsoft .NET Technologies Interview Questions and Answers

 

Explain all the classes those are used for database connections between sql server and asp.net?

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.

Posted by:Richards