This topic has not yet been rated - Rate this topic

SqlDatabase Methods

Retired Content
This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

The SqlDatabase type exposes the following members.

Methods

	Name	Description
	AddInParameter	Overloaded.
	AddOutParameter	Overloaded.
	AddParameter	Overloaded.
	BuildParameterName	Builds a value parameter name for the current database. (Overrides DatabaseBuildParameterName(String).)
	ConfigureParameter	Overloaded.
	CreateConnection	Creates a connection for this database. (Inherited from Database.)
	CreateParameter	Overloaded.
	DeriveParameters	Retrieves parameter information from the stored procedure specified in the DbCommand and populates the Parameters collection of the specified DbCommand object. (Overrides DatabaseDeriveParameters(DbCommand).)
	DiscoverParameters	Discovers the parameters for a DbCommand. (Inherited from Database.)
	DoExecuteNonQuery	Executes the query for command. (Inherited from Database.)
	Equals	(Inherited from Object.)
	ExecuteDataSet	Overloaded.
	ExecuteNonQuery	Overloaded.
	ExecuteReader	Overloaded.
	ExecuteScalar	Overloaded.
	ExecuteXmlReader	Overloaded.
	Finalize	(Inherited from Object.)
	GetDataAdapter	Overloaded.
	GetHashCode	(Inherited from Object.)
	GetInstrumentationEventProvider	Returns the object to which the instrumentation events have been delegated. (Inherited from Database.)
	GetOpenConnection	Overloaded.
	GetParameterValue	Gets a parameter value. (Inherited from Database.)
	GetSqlStringCommand	Creates a DbCommand for a SQL query. (Inherited from Database.)
	GetStoredProcCommand	Overloaded.
	GetStoredProcCommandWithSourceColumns	Wraps around a derived class's implementation of the GetStoredProcCommandWrapper method and adds functionality for using this method with UpdateDataSet. The GetStoredProcCommandWrapper method (above) that takes a params array expects the array to be filled with VALUES for the parameters. This method differs from the GetStoredProcCommandWrapper method in that it allows a user to pass in a string array. It will also dynamically discover the parameters for the stored procedure and set the parameter's SourceColumns to the strings that are passed in. It does this by mapping the parameters to the strings IN ORDER. Thus, order is very important. (Inherited from Database.)
	GetType	(Inherited from Object.)
	LoadDataSet	Overloaded.
	MemberwiseClone	(Inherited from Object.)
	OpenConnection	Obsolete. Opens a connection. (Inherited from Database.)
	SameNumberOfParametersAndValues	Determines if the number of parameters in the command matches the array of parameter values. (Overrides DatabaseSameNumberOfParametersAndValues(DbCommand, Object).)
	SetParameterValue	Sets a parameter value. (Inherited from Database.)
	SetUpRowUpdatedEvent	Sets the RowUpdated event for the data adapter. (Overrides DatabaseSetUpRowUpdatedEvent(DbDataAdapter).)
	ToString	(Inherited from Object.)
	UpdateDataSet	Overloaded.
	UserParametersStartIndex	Returns the starting index for parameters in a command. (Overrides DatabaseUserParametersStartIndex.)