ExecuteSql Class

Definition

Namespace:

Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

this class is used to execute tsql it is the only way tsql gets executed by the enumerator

[System.Runtime.InteropServices.ComVisible(false)]
public class ExecuteSql

[<System.Runtime.InteropServices.ComVisible(false)>]
type ExecuteSql = class

Public Class ExecuteSql

Inheritance

Object

ExecuteSql

Attributes

ComVisibleAttribute

Constructors

ExecuteSql(Object)

init connection trying to cast con to one of the supported connection types

Methods

ExecuteImmediate(String, Object)	execute the sql for ther given connection without returning results
ExecuteImmediate(String)	execute a query without results
ExecuteImmediateGetMessage(String, Object)	execute the sql for ther given connection without returning results but capturing the messages
ExecuteWithResults(String, Object)	execute the sql for ther given connection returning results in a DataTable
ExecuteWithResults(String)	excute a query and return a DataTable with the results
ExecuteWithResults(StringCollection, Object, StatementBuilder)	execute the sql for ther given connection returning results in a DataTable this is a tsql for final results StatementBuilder holds info for additional processing needs and formating information the first tsqls in the list are executed without resulst, results are taken only for the last tsql
ExecuteWithResults(StringCollection, Object)	execute tsql for the given connection and return the results in the DataTable
GetDatabaseEngineEdition()	Returns the DatabaseEngineEdition for the connection
GetDatabaseEngineEdition(Object)	return the DatabaseEngineEdition for the server with the given connection
GetDatabaseEngineType()	return the DatabaseEngineType for the connection
GetDatabaseEngineType(Object)	return the database engine type for the server with the given connection
GetDataReader(String, SqlCommand)	Execute a query and get a DataReader for the results.
GetDataReader(String)	Execute a query and get a DataReader for the results.
GetHostPlatform(Object)	Returns the HostPlatform property of the connection
GetServerVersion()	return the ServerVersion for the connection
GetServerVersion(Object)	return the server version for the server with the given connection
IsContainedAuthentication(Object)	returns if authentication is contained