Get benefited from interview Q/A and Online Test section. Subscribe to this blog to get updates directly in your mail box.
Best View in Google Crome, Mozilla firefox or IE 7 or above

Tuesday, February 12, 2013

What are the commonly used classes in System.Data.SqlClient?



Here are the commonly used classes in System.Data.SqlClient:

SqlCommand:
Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database.

SqlCommandBuilder:
Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database.

SqlConnection:
Represents an open connection to a SQL Server database.

SqlDataAdapter:
Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database.

SqlDataReader:
Provides a means of reading a forward-only stream of rows from a SQL Server database.

SqlTransaction:
Represents a Transact-SQL transaction to be made in a SQL Server database.

For more ADO.Net Interview Questions, click here.




2 comments:

  1. Your information about asp is really interesting and innovative. Also I want you to share latest updates about asp. Can you update it in your website? Thanks for sharing

    ReplyDelete
  2. Sure. I will update ASP questions as well. Thank you for your suggestion.

    ReplyDelete

  © Blogger templates Shiny by Ourblogtemplates.com 2008

Back to TOP