SqlEnumResult Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:: Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

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.

derives from the enumerator EnumResult too add sql extension specific functionality

[System.Runtime.InteropServices.ComVisible(false)]
public class SqlEnumResult : Microsoft.SqlServer.Management.Sdk.Sfc.EnumResult

[<System.Runtime.InteropServices.ComVisible(false)>]
type SqlEnumResult = class
    inherit EnumResult

Public Class SqlEnumResult
Inherits EnumResult

Inheritance: Object

EnumResult
SqlEnumResult

Attributes: ComVisibleAttribute

Constructors

SqlEnumResult(Object, ResultType, DatabaseEngineType)

constructor, receives a StatementBuilder and a ResultType

Properties

CommandElapsedTime	The time spent executing the command. Not valid if CommandText is empty. (Inherited from EnumResult)
CommandText	The text of the command that was used to generate the result. Can be null. (Inherited from EnumResult)
Data	result data (Inherited from EnumResult)
Databases	list of databases trough which the query must be executed can have multiple database levels
LastDbLevelSet	no further procesing is necessary for the database level set in DatabaseLevel
Level	How many databases deep are we
NameProperties	property name for database used in DatabaseLevel
PostProcessFields	unused ????
SchemaPrefixes	list of schemas that must be substituted into the query
SchemaPrefixProperties	property name for schema used in the DatabaseLevel
StatementBuilder	get/set the StatementBuilder
Type	in what kind of storage is the data in the result (Inherited from EnumResult)

Methods

BuildSql()	return the tsql that will provide the result for the user
SetType(ResultType)	used to set the result type on the data is filled (Inherited from EnumResult)

Applies to

Share via