DataSourceInformation Class

Definition

Allows you to retrieve well-defined information about a specified data source in the form of properties constructed as name/value pairs.

public ref class DataSourceInformation abstract : Microsoft::VisualStudio::Data::Framework::DataSiteableObject<Microsoft::VisualStudio::Data::Services::IVsDataConnection ^>, Microsoft::VisualStudio::Data::Services::SupportEntities::IVsDataSourceInformation
public abstract class DataSourceInformation : Microsoft.VisualStudio.Data.Framework.DataSiteableObject<Microsoft.VisualStudio.Data.Services.IVsDataConnection>, Microsoft.VisualStudio.Data.Services.SupportEntities.IVsDataSourceInformation
type DataSourceInformation = class
    inherit DataSiteableObject<IVsDataConnection>
    interface IVsDataSourceInformation
Public MustInherit Class DataSourceInformation
Inherits DataSiteableObject(Of IVsDataConnection)
Implements IVsDataSourceInformation
Inheritance
Derived
Implements

Constructors

DataSourceInformation()

Initializes a new instance of the DataSourceInformation class.

DataSourceInformation(IVsDataConnection)

Initializes a parameterized instance of the DataSourceInformation class that provides the data connection.

Fields

CatalogInvalidCharacters

Specifies the data source information property that provides a string of characters that are not valid, 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 whether 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 whether a catalog name is supported in a multi-part object identifier.

CatalogSupportedInDml

Specifies the data source information property that indicates whether 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 whether 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 whether a column name is supported in a multi-part object identifier.

CommandDeriveParametersSupport

Specifies what types of commands are supported by the DeriveParameters(String, DataCommandType, Int32) method.

CommandDeriveSchemaSupport

Specifies what types of commands are supported by the DeriveSchema(String, DataCommandType, IVsDataParameter[], Int32) method.

CommandExecuteSupport

Specifies what types of commands are supported by the Execute(String, DataCommandType, IVsDataParameter[], Int32) and ExecuteWithoutResults(String, DataCommandType, IVsDataParameter[]) methods.

CommandParameterSupport

Specifies which parameter directions are supported.

CommandPrepareSupport

Specifies which types of commands are supported by the Prepare(String, DataCommandType) 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 or characters that prefix a date/time literal.

DateLiteralSuffix

Specifies the data source information property that provides the character or characters that suffix a date/time literal.

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 enclosed in quotation marks.

IdentifierPartsCaseSensitive

Specifies the data source information property that indicates whether identifier parts are treated as case sensitive.

IdentifierPartsStorageCase

Specifies the data source information property that indicates the case of identifier parts that 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 whether 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 character 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 whether 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 whether a procedure name is supported in a multi-part object identifier.

QuotedIdentifierPartsCaseSensitive

Specifies the data source information property that indicates whether identifier parts enclosed in quotation marks are treated as case sensitive.

QuotedIdentifierPartsStorageCase

Specifies the data source information property that indicates the case of identifier parts enclosed in quotation marks that 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 of an object identifier.

SchemaSupported

Specifies the data source information property that indicates whether a schema name is supported in a multi-part object identifier.

SchemaSupportedInDml

Specifies the data source information property that indicates whether 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 of an object identifier.

SupportsAnsi92Sql

Specifies the data source information property that indicates whether 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 identifier parts enclosed in quotation marks are supported.

SupportsVerifySql

Specifies the data source information property that indicates whether 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 whether 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 whether 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 whether 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 whether a view name is supported in a multi-part object identifier.

Properties

Item[String]

Gets a data source information property with the specified name.

Site

Gets or sets the object site.

(Inherited from DataSiteableObject<T>)

Methods

AddProperty(String)

Adds a property to the list of supported properties.

AddProperty(String, Object)

Adds a property and its value 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.

GetType(String)

Retrieves the Type value indicating the type of a specified property, thus enabling appropriate conversion of a retrieved value to the correct type.

OnSiteChanged(EventArgs)

Raises the SiteChanged event.

(Inherited from DataSiteableObject<T>)
RetrieveValue(String)

Retrieves a value for a specified data source information property.

Events

SiteChanged

Occurs when the Site property is changed.

(Inherited from DataSiteableObject<T>)

Applies to