SfcObjectQuery Class

Definition

Namespace:

Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

public class SfcObjectQuery

type SfcObjectQuery = class

Public Class SfcObjectQuery

Inheritance

Object

SfcObjectQuery

Constructors

SfcObjectQuery(IAlienRoot)
SfcObjectQuery(ISfcDomain, SfcObjectQueryMode)	Create an object query for a particular domain instance. The query mode determines how requests to return an open iterator are handled and the particular connection to use.
SfcObjectQuery(ISfcDomain)	Create an object query for a particular domain instance object hierarchy and connection. If you use ExecuteIterator and want to make another query before closing it, consider using the overload which indicates support for multiple active queries, or simply use ExecuteCollection to avoid it.

Properties

ActiveQueriesMode	Single or multiple active queries? If multiple queries is indicated, then the connection returned must be capable of performing a query and getting results assuming the main connection is busy with an already-active query.
SfcQueryExpression	The most recent query string processed. This is readonly since each query execution is passed the query to perform.

Methods

ExecuteDataTable(SfcQueryExpression, String[], OrderBy[])	Execute the query string to retrieve the specified fields and return a fully populated DataTable.
ExecuteIterator(SfcQueryExpression, String[], OrderBy[])	Execute the query string and return an SfcObjectIterator to enumerate the results without caching them. If MultipleActiveQueries is true, then you must either provide a suitable connection when requests by GetConnection or use the ExecuteCachedIterator instead to avoid this issue.