Allows you to retrieve well-defined information about a specified data source in the form of properties passed as name/value pairs.
The DataSourceInformation type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
![]() |
DataSourceInformation | Overloaded. |
Top
Methods
| Name | Description | |
|---|---|---|
![]() |
AddProperty | Overloaded. |
![]() |
Contains | Retrieves a Boolean value indicating whether a specified property is contained in this data source information instance. |
![]() |
Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() |
Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
![]() |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() |
GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() |
OnSiteChanged | Raises the SiteChanged event. (Inherited from ObjectWithSite.) |
![]() |
RetrieveValue | Retrieves a value for a specified data source information property. |
![]() |
ToString | Returns a String that represents the current Object. (Inherited from Object.) |
Top
Fields
| Name | Description | |
|---|---|---|
![]() ![]() |
CatalogInvalidCharacters | Specifies the data source information property that provides a string of characters that are invalid, that is, that may not appear in a generic catalog name. |
![]() ![]() |
CatalogInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose use at the start of a generic catalog name is not valid. |
![]() ![]() |
CatalogIsSuffixed | Specifies the data source information property that indicates if a catalog name is suffixed on a multi-part object identifier, as opposed to being a prefix. |
![]() ![]() |
CatalogMaxLength | Specifies the data source information property that indicates the maximum length of a catalog name. |
![]() ![]() |
CatalogSeparator | Specifies the data source information property that indicates the character separating a catalog name from the other parts in an object identifier. |
![]() ![]() |
CatalogSupported | Specifies the data source information property that indicates if a catalog name is supported in a multi-part object identifier. |
![]() ![]() |
CatalogSupportedInDml | Specifies the data source information property that indicates if a catalog name is supported in object identifiers that appear in SQL DML clauses. |
![]() ![]() |
ColumnAliasInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a column alias is not valid. |
![]() ![]() |
ColumnAliasInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a column alias is not valid. |
![]() ![]() |
ColumnAliasMaxLength | Specifies the data source information property that indicates the maximum length of a column alias. |
![]() ![]() |
ColumnAliasSupported | Specifies the data source information property that indicates if a column alias is supported in a multi-part object identifier. |
![]() ![]() |
ColumnInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a column name is not valid. |
![]() ![]() |
ColumnInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a column name is not valid. |
![]() ![]() |
ColumnMaxLength | Specifies the data source information property that indicates the maximum length of a column name. |
![]() ![]() |
ColumnSupported | Specifies the data source information property that indicates if a column name is supported in a multi-part object identifier. |
![]() ![]() |
CommandDeriveParametersSupport | Specifies what types of commands are supported by the DeriveParameters method. |
![]() ![]() |
CommandDeriveSchemaSupport | Specifies what types of commands are supported by the DeriveSchema method. |
![]() ![]() |
CommandExecuteSupport | Specifies what types of commands are supported by the Execute and ExecuteWithoutResults methods. |
![]() ![]() |
CommandParameterSupport | Specifies what parameter directions are supported. |
![]() ![]() |
CommandPrepareSupport | Specifies what types of commands are supported by the Prepare method. |
![]() ![]() |
DataSourceCulture | Specifies the geographical culture of the data source. |
![]() ![]() |
DataSourceName | Specifies the name of the data source. |
![]() ![]() |
DataSourceProduct | Specifies the name of the product of the data source. |
![]() ![]() |
DataSourceVersion | Specifies the version of the data source. |
![]() ![]() |
DateLiteralPrefix | Specifies the data source information property that provides the character(s) that prefix a date/time literal. |
![]() ![]() |
DateLiteralSuffix | Specifies the data source information property that provides the character(s) that suffix a date/time literal. |
![]() ![]() |
Default | Provides a default instance of the DataSourceInformation class for use when a data provider does not provide their own implementation. |
![]() ![]() |
DefaultCatalog | Specifies the data source information property that provides the name of the default catalog. |
![]() ![]() |
DefaultSchema | Specifies the data source information property that provides the name of the default schema. |
![]() ![]() |
IdentifierCloseQuote | Specifies the data source information property that provides the character used to close an identifier part that needs to be enclosed in quotation marks. |
![]() ![]() |
IdentifierOpenQuote | Specifies the data source information property that provides the character used to open an identifier part that needs to be quoted. |
![]() ![]() |
IdentifierPartsCaseSensitive | Specifies the data source information property that indicates if identifier parts are treated as case sensitive. |
![]() ![]() |
IdentifierPartsStorageCase | Specifies the data source information property that indicates what case identifier parts are stored in the data source. |
![]() ![]() |
IndexInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance as an index name is not valid. |
![]() ![]() |
IndexInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of an index name is not valid. |
![]() ![]() |
IndexMaxLength | Specifies the data source information property that indicates the maximum length of an index name. |
![]() ![]() |
IndexSupported | Specifies the data source information property that indicates if an index name is supported in a multi-part object identifier. |
![]() ![]() |
LikeClausePercent | Specifies the data source information property that indicates the wildcard character used to capture zero or more characters within values for a LIKE clause in a SQL DML statement. |
![]() ![]() |
LikeClausePercentEscape | Specifies the data source information property that indicates the character used to escape the LikeClausePercent character within values for a LIKE clause in a SQL DML statement. |
![]() ![]() |
LikeClauseUnderscore | Specifies the data source information property that indicates the wildcard character used to capture a single characters within values for a LIKE clause in a SQL DML statement. |
![]() ![]() |
LikeClauseUnderscoreEscape | Specifies the data source information property that indicates the character used to escape the LikeClauseUnderscore character within values for a LIKE clause in a SQL DML statement. |
![]() ![]() |
ParameterPrefix | Specifies the data source information property that provides the character used to prefix a parameter name. |
![]() ![]() |
ParameterPrefixInName | Specifies the data source information property that indicates if the parameter prefix should appear in the value set for the Name property. |
![]() ![]() |
ProcedureInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a procedure name is not valid. |
![]() ![]() |
ProcedureInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a procedure name is not valid. |
![]() ![]() |
ProcedureMaxLength | Specifies the data source information property that indicates the maximum length of a procedure name. |
![]() ![]() |
ProcedureSupported | Specifies the data source information property that indicates if a procedure name is supported in a multi-part object identifier. |
![]() ![]() |
QuotedIdentifierPartsCaseSensitive | Specifies the data source information property that indicates if quoted identifier parts are treated as case sensitive. |
![]() ![]() |
QuotedIdentifierPartsStorageCase | Specifies the data source information property that indicates what case quoted identifier parts are stored in the data source. |
![]() ![]() |
ReservedWords | Specifies the data source information property that provides the set of reserved words on the data source. |
![]() ![]() |
SchemaInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a schema name is not valid. |
![]() ![]() |
SchemaInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a schema name is not valid. |
![]() ![]() |
SchemaMaxLength | Specifies the data source information property that indicates the maximum length of a schema name. |
![]() ![]() |
SchemaSeparator | Specifies the data source information property that indicates the character separating a schema name from the other parts in an object identifier. |
![]() ![]() |
SchemaSupported | Specifies the data source information property that indicates if a schema name is supported in a multi-part object identifier. |
![]() ![]() |
SchemaSupportedInDml | Specifies the data source information property that indicates if a schema name is supported in object identifiers that appear in SQL DML clauses. |
![]() ![]() |
ServerSeparator | Specifies the data source information property that indicates the character separating a server name from the other parts in an object identifier. |
![]() ![]() |
SupportsAnsi92Sql | Specifies the data source information property that indicates if the data source supports the ANSI92 SQL standard. |
![]() ![]() |
SupportsCommandTimeout | Specifies the data source information property that indicates whether command timeouts are supported. |
![]() ![]() |
SupportsNestedTransactions | Specifies the data source information property that indicates whether transactions can be started, committed, or rolled back inside other transactions. |
![]() ![]() |
SupportsQuotedIdentifierParts | Specifies the data source information property that indicates whether quoted identifier parts are supported. |
![]() ![]() |
SupportsVerifySql | Specifies the data source information property that indicates if SQL verification is supported. |
![]() ![]() |
TableAliasInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a table alias is not valid. |
![]() ![]() |
TableAliasInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a table alias is not valid. |
![]() ![]() |
TableAliasMaxLength | Specifies the data source information property that indicates the maximum length of a table alias. |
![]() ![]() |
TableAliasSupported | Specifies the data source information property that indicates if a table alias is supported in a multi-part object identifier. |
![]() ![]() |
TableInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a table name is not valid. |
![]() ![]() |
TableInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a table name is not valid. |
![]() ![]() |
TableMaxLength | Specifies the data source information property that indicates the maximum length of a table name. |
![]() ![]() |
TableSupported | Specifies the data source information property that indicates if a table name is supported in a multi-part object identifier. |
![]() ![]() |
UserInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a user name is not valid. |
![]() ![]() |
UserInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a user name is not valid. |
![]() ![]() |
UserMaxLength | Specifies the data source information property that indicates the maximum length of a user name. |
![]() ![]() |
UserSupported | Specifies the data source information property that indicates if a user name is supported in a multi-part object identifier. |
![]() ![]() |
ViewInvalidCharacters | Specifies the data source information property that provides a string of characters whose appearance in a view name is not valid. |
![]() ![]() |
ViewInvalidStartCharacters | Specifies the data source information property that provides a string of characters whose appearance at the start of a view name is not valid. |
![]() ![]() |
ViewMaxLength | Specifies the data source information property that indicates the maximum length of a view name. |
![]() ![]() |
ViewSupported | Specifies the data source information property that indicates if a view name is supported in a multi-part object identifier. |
Top
Properties
| Name | Description | |
|---|---|---|
![]() |
Connection | Retrieves the data connection used to retrieve data source properties. |
![]() |
ConnectionSupport | Retrieves the provider connection support object associated with the data connection. |
![]() |
Item | Retrieves a data source information property with the specified name. |
![]() |
ProviderObject | Retrieves the underlying provider connection object as exposed by the connection support object. |
![]() |
Site | Retrieves or sets the object site. (Inherited from ObjectWithSite.) |
Top
Events
| Name | Description | |
|---|---|---|
![]() |
SiteChanged | Event that is raised when the Site property is changed. (Inherited from ObjectWithSite.) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
![]() ![]() |
IObjectWithSite.GetSite | Retrieves the last site set using the IObjectWithSite.SetSite method. In cases where there is no known site, the object returns an exception. (Inherited from ObjectWithSite.) |
![]() ![]() |
IObjectWithSite.SetSite | Provides the site's pointer to the site object. (Inherited from ObjectWithSite.) |
Top
.gif)
.gif)
.gif)
.gif)
.gif)
.gif)
.gif)
.gif)
.gif)