ExecuteSql Class
Definition
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.
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 = classPublic Class ExecuteSql- Inheritance
-
ExecuteSql
- Attributes
Constructors
| ExecuteSql(Object) |
init connection trying to cast con to one of the supported connection types |
Methods
| ExecuteImmediate(String) |
execute a query without results |
| ExecuteImmediate(String, Object) |
execute the sql for ther given connection without returning results |
| ExecuteImmediateGetMessage(String, Object) |
execute the sql for ther given connection without returning results but capturing the messages |
| ExecuteWithResults(String) |
excute a query and return a DataTable with the results |
| ExecuteWithResults(String, Object) |
execute the sql for ther given connection returning results in a DataTable |
| ExecuteWithResults(StringCollection, Object) |
execute tsql for the given connection and return the results in the DataTable |
| 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 |
| 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) |
Execute a query and get a DataReader for the results. |
| GetDataReader(String, SqlCommand) |
Execute a query and get a DataReader for the results. |
| GetDataReader(String, SqlCommand) | |
| 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 |