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.




What is the Namespace for using SQL Server database in Dotnet Application?

System.Data.SqlClient namespace is the .NET Framework Data Provider for SQL Server.

The .NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space. Using the SqlDataAdapter, you can fill a memory-resident DataSet, which you can use to query and update the database.

For the commonly used classes in System.Data.SqlClient, click here.

For more ADO.Net Interview Questions, click here.

  © Blogger templates Shiny by Ourblogtemplates.com 2008

Back to TOP