DataSourceInformation Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Allows you to retrieve well-defined information about a specified data source in the form of properties passed as name/value pairs.
public ref class DataSourceInformation : Microsoft::VisualStudio::Data::ObjectWithSite[System.Runtime.InteropServices.Guid("EF852E1E-DD85-4400-A5BE-96A14F32B7E0")]
public class DataSourceInformation : Microsoft.VisualStudio.Data.ObjectWithSite[<System.Runtime.InteropServices.Guid("EF852E1E-DD85-4400-A5BE-96A14F32B7E0")>]
type DataSourceInformation = class
inherit ObjectWithSitePublic Class DataSourceInformation
Inherits ObjectWithSite- Inheritance
- Derived
- Attributes
Constructors
| DataSourceInformation() |
Class constructor. Instantiates a nonparameterized instance of the DataSourceInformation class. |
| DataSourceInformation(DataConnection, ICollection) |
Class constructor. Instantiates a parameterized instance of the DataSourceInformation class, along with the specific connection and an ICollection object containing the connection property names.. |
| DataSourceInformation(DataConnection, IDictionary) |
Class constructor. Instantiates a parameterized instance of the DataSourceInformation class along with a specific data connection and an IDictionary object containing connection properties information. |
| DataSourceInformation(DataConnection) |
Class constructor. Instantiates a parameterized instance of the DataSourceInformation class that provides the data connection for which the information is provided. |
Fields
| 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(String, Int32, Int32) method. |
| CommandDeriveSchemaSupport |
Specifies what types of commands are supported by the DeriveSchema(String, Int32, DataParameter[], Int32) method. |
| CommandExecuteSupport |
Specifies what types of commands are supported by the Execute(String, Int32, DataParameter[], Int32) and ExecuteWithoutResults(String, Int32, DataParameter[], Int32) methods. |
| CommandParameterSupport |
Specifies what parameter directions are supported. |
| CommandPrepareSupport |
Specifies what types of commands are supported by the Prepare(String, Int32, Int32) 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. |
Properties
| Connection |
Retrieves the data connection used to retrieve data source properties. |
| ConnectionSupport |
Retrieves the provider connection support object associated with the data connection. |
| Item[String] |
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) |
Methods
| AddProperty(String, Object) |
Adds a property and its value to the list of supported properties. |
| AddProperty(String) |
Adds a property to the list of supported properties. |
| Contains(String) |
Retrieves a Boolean value indicating whether a specified property is contained in this data source information instance. |
| OnSiteChanged(EventArgs) |
Raises the SiteChanged event. (Inherited from ObjectWithSite) |
| RetrieveValue(String) |
Retrieves a value for a specified data source information property. |
Events
| SiteChanged |
Event that is raised when the Site property is changed. (Inherited from ObjectWithSite) |
Explicit Interface Implementations
| IObjectWithSite.GetSite(Guid, IntPtr) |
Retrieves the last site set using the IObjectWithSite.SetSite(Object) method. In cases where there is no known site, the object returns an exception. (Inherited from ObjectWithSite) |
| IObjectWithSite.SetSite(Object) |
Provides the site's pointer to the site object. (Inherited from ObjectWithSite) |