Freigeben über

AdoDotNetConnectionSupport.DeriveSchemaCore Method

  • Artikel

Derives the schema returned from a specified command, indicating the layout of items and blocks in a given data reader.

Namespace:  Microsoft.VisualStudio.Data.Framework.AdoDotNet
Assembly:  Microsoft.VisualStudio.Data.Framework (in Microsoft.VisualStudio.Data.Framework.dll)

Syntax

'Declaration
Protected Overridable Function DeriveSchemaCore ( _
    command As String, _
    commandType As DataCommandType, _
    parameters As IVsDataParameter(), _
    commandTimeout As Integer _
) As IVsDataReader

protected virtual IVsDataReader DeriveSchemaCore(
    string command,
    DataCommandType commandType,
    IVsDataParameter[] parameters,
    int commandTimeout
)

protected:
virtual IVsDataReader^ DeriveSchemaCore(
    String^ command, 
    DataCommandType commandType, 
    array<IVsDataParameter^>^ parameters, 
    int commandTimeout
)

abstract DeriveSchemaCore : 
        command:string * 
        commandType:DataCommandType * 
        parameters:IVsDataParameter[] * 
        commandTimeout:int -> IVsDataReader 
override DeriveSchemaCore : 
        command:string * 
        commandType:DataCommandType * 
        parameters:IVsDataParameter[] * 
        commandTimeout:int -> IVsDataReader 

protected function DeriveSchemaCore(
    command : String, 
    commandType : DataCommandType, 
    parameters : IVsDataParameter[], 
    commandTimeout : int
) : IVsDataReader

Parameters

  • command
    Type: System.String
    Data source–specific command for which to derive the schema.
  • commandTimeout
    Type: System.Int32
    Length of time, in seconds, to block the client before canceling the schema derivation and returning to the caller. A value of zero indicates infinite time-out; value of -1 indicates a provider default.

Return Value

Type: Microsoft.VisualStudio.Data.Services.SupportEntities.IVsDataReader
An IVsDataReader object instance representing the command schema.

Remarks

The schema of the data reader returned by this method must follow a specific format. For each result that would be returned when executing the command, there should be a result in the data reader. Each of these results should contain blocks that describe the items that would be returned when executing the command. The description should contain the following items:

  • Name (String): the name of the item.

  • Ordinal (Int32): the position of the item.

  • UserDataType (String): the user data type of the item (for example, "myType").

  • NativeDataType (String): the native data type of the item (for example, "nvarchar").

  • ProviderDataType (Int32): the provider data type of the item (for example, System.Data.DbType.StringFixedLength).

  • FrameworkDataType (Type): the framework data type of the item (for example, System.Int32).

  • Length (Int32): the maximum length of the item, if applicable.

  • Precision (Int32): the precision of the item, if applicable.

  • Scale (Int32): the scale of the item, if applicable.

  • Nullable (Boolean): the nullability of the item.

Those items that a provider does not support (for example, some forms of the data type) should be present but set to nulla null reference (Nothing in Visual Basic).

.NET Framework Security

See Also

Reference

AdoDotNetConnectionSupport Class

Microsoft.VisualStudio.Data.Framework.AdoDotNet Namespace

DeriveSchema