SqlDatabase Members

Include Protected Members
Include Inherited Members

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.

Constructors

	Name	Description
	SqlDatabase	Initializes a new instance of the SqlDatabase class with a connection string.

Methods

	Name	Description
	AddInParameter	Overloaded.
	AddOutParameter	Overloaded.
	AddParameter	Overloaded.
	BuildParameterName	Builds a value parameter name for the current database. (Overrides Database.BuildParameterName(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 Database.DeriveParameters(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 Database.SameNumberOfParametersAndValues(DbCommand, array<Object>).)
	SetParameterValue	Sets a parameter value. (Inherited from Database.)
	SetUpRowUpdatedEvent	Sets the RowUpdated event for the data adapter. (Overrides Database.SetUpRowUpdatedEvent(DbDataAdapter).)
	ToString	(Inherited from Object.)
	UpdateDataSet	Overloaded.
	UserParametersStartIndex	Returns the starting index for parameters in a command. (Overrides Database.UserParametersStartIndex().)

Fields

	Name	Description
	instrumentationProvider	The DataInstrumentationProvider instance that defines the logical events used to instrument this Database instance. (Inherited from Database.)

Properties

	Name	Description
	ConnectionString	Gets the string used to open a database. (Inherited from Database.)
	ConnectionStringNoCredentials	Gets the connection string without the username and password. (Inherited from Database.)
	ConnectionStringWithoutCredentials	Gets the connection string without credentials. (Inherited from Database.)
	DbProviderFactory	Gets the DbProviderFactory used by the database instance. (Inherited from Database.)
	ParameterToken	Gets the parameter token used to delimit parameters for the SQL Server database.

See Also

SqlDatabase Class

Microsoft.Practices.EnterpriseLibrary.Data.Sql Namespace

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.