Database 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 Database type exposes the following members.

Constructors

	Name	Description
	Database	Initializes a new instance of the Database class with a connection string and a DbProviderFactory.

Methods

	Name	Description
	AddInParameter	Overloaded.
	AddOutParameter	Adds a new Out DbParameter object to the given command.
	AddParameter	Overloaded.
	BuildParameterName	Builds a value parameter name for the current database.
	ClearParameterCache	Clears the parameter cache. Since there is only one parameter cache that is shared by all instances of this class, this clears all parameters cached for all databases.
	ConfigureParameter	Configures a given DbParameter.
	CreateConnection	Creates a connection for this 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.
	DiscoverParameters	Discovers the parameters for a DbCommand.
	DoExecuteNonQuery	Executes the query for command.
	Equals	(Inherited from Object.)
	ExecuteDataSet	Overloaded.
	ExecuteNonQuery	Overloaded.
	ExecuteReader	Overloaded.
	ExecuteScalar	Overloaded.
	Finalize	(Inherited from Object.)
	GetDataAdapter	Overloaded.
	GetHashCode	(Inherited from Object.)
	GetInstrumentationEventProvider	Returns the object to which the instrumentation events have been delegated.
	GetOpenConnection	Overloaded.
	GetParameterValue	Gets a parameter value.
	GetSqlStringCommand	Creates a DbCommand for a SQL query.
	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.
	GetType	(Inherited from Object.)
	LoadDataSet	Overloaded.
	MemberwiseClone	(Inherited from Object.)
	OpenConnection	Obsolete. Opens a connection.
	PrepareCommand	Overloaded.
	SameNumberOfParametersAndValues	Determines if the number of parameters in the command matches the array of parameter values.
	SetParameterValue	Sets a parameter value.
	SetUpRowUpdatedEvent	Sets the RowUpdated event for the data adapter.
	ToString	(Inherited from Object.)
	UpdateDataSet	Overloaded.
	UserParametersStartIndex	Returns the starting index for parameters in a command.

Fields

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

Properties

	Name	Description
	ConnectionString	Gets the string used to open a database.
	ConnectionStringNoCredentials	Gets the connection string without the username and password.
	ConnectionStringWithoutCredentials	Gets the connection string without credentials.
	DbProviderFactory	Gets the DbProviderFactory used by the database instance.

See Also

Database Class

Microsoft.Practices.EnterpriseLibrary.Data 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.