Partager via

SqlDatabase Members

  • Article

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
Public method SqlDatabase
Initializes a new instance of the SqlDatabase class with a connection string.

Methods

  Name Description
Public method AddInParameter Overloaded.
Public method AddOutParameter Overloaded.
Public method AddParameter Overloaded.
Public method BuildParameterName
Builds a value parameter name for the current database.
(Overrides Database.BuildParameterName(String).)
Protected method ConfigureParameter Overloaded.
Public method CreateConnection

Creates a connection for this database.

(Inherited from Database.)
Protected method CreateParameter Overloaded.
Protected method 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).)
Public method DiscoverParameters
Discovers the parameters for a DbCommand.
(Inherited from Database.)
Protected method DoExecuteNonQuery
Executes the query for command.
(Inherited from Database.)
Public method Equals (Inherited from Object.)
Public method ExecuteDataSet Overloaded.
Public method ExecuteNonQuery Overloaded.
Public method ExecuteReader Overloaded.
Public method ExecuteScalar Overloaded.
Public method ExecuteXmlReader Overloaded.
Protected method Finalize (Inherited from Object.)
Public method GetDataAdapter Overloaded.
Public method GetHashCode (Inherited from Object.)
Public method GetInstrumentationEventProvider
Returns the object to which the instrumentation events have been delegated.
(Inherited from Database.)
Protected method GetOpenConnection Overloaded.
Public method GetParameterValue
Gets a parameter value.
(Inherited from Database.)
Public method GetSqlStringCommand

Creates a DbCommand for a SQL query.

(Inherited from Database.)
Public method GetStoredProcCommand Overloaded.
Public method 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.)
Public method GetType (Inherited from Object.)
Public method LoadDataSet Overloaded.
Protected method MemberwiseClone (Inherited from Object.)
Protected method OpenConnection Obsolete.

Opens a connection.

(Inherited from Database.)
Protected method SameNumberOfParametersAndValues
Determines if the number of parameters in the command matches the array of parameter values.
(Overrides Database.SameNumberOfParametersAndValues(DbCommand, array<Object>).)
Public method SetParameterValue
Sets a parameter value.
(Inherited from Database.)
Protected method SetUpRowUpdatedEvent
Sets the RowUpdated event for the data adapter.
(Overrides Database.SetUpRowUpdatedEvent(DbDataAdapter).)
Public method ToString (Inherited from Object.)
Public method UpdateDataSet Overloaded.
Protected method UserParametersStartIndex
Returns the starting index for parameters in a command.
(Overrides Database.UserParametersStartIndex().)

Fields

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

Properties

  Name Description
Protected property ConnectionString

Gets the string used to open a database.

(Inherited from Database.)
Protected property ConnectionStringNoCredentials

Gets the connection string without the username and password.

(Inherited from Database.)
Public property ConnectionStringWithoutCredentials
Gets the connection string without credentials.
(Inherited from Database.)
Public property DbProviderFactory

Gets the DbProviderFactory used by the database instance.

(Inherited from Database.)
Protected property 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.