SqlCommand
E827340
SqlCommand is an ADO.NET class used to define and execute SQL statements and stored procedures against a SQL Server database.
Statements (48)
| Predicate | Object |
|---|---|
| instanceOf |
ADO.NET class
ⓘ
class ⓘ |
| belongsToFramework |
.NET 5+
NERFINISHED
ⓘ
.NET Core NERFINISHED ⓘ .NET Framework NERFINISHED ⓘ |
| canBeUsedWith |
parameterized queries
ⓘ
transactions ⓘ |
| defaultCommandTimeoutSeconds | 30 ⓘ |
| definedIn | System.Data.SqlClient namespace NERFINISHED ⓘ |
| definedInAssembly | System.Data.dll NERFINISHED ⓘ |
| documentationUrl | https://learn.microsoft.com/dotnet/api/system.data.sqlclient.sqlcommand ⓘ |
| hasMethod |
BeginExecuteNonQuery
ⓘ
BeginExecuteReader ⓘ BeginExecuteXmlReader ⓘ Cancel ⓘ EndExecuteNonQuery ⓘ EndExecuteReader ⓘ EndExecuteXmlReader ⓘ ExecuteNonQuery ⓘ ExecuteReader ⓘ ExecuteScalar ⓘ ExecuteXmlReader ⓘ Prepare ⓘ |
| hasProperty |
CommandText
ⓘ
CommandTimeout ⓘ CommandType ⓘ Connection ⓘ Parameters ⓘ Transaction ⓘ UpdatedRowSource ⓘ |
| implements | IDbCommand ⓘ |
| inheritsFrom | DbCommand NERFINISHED ⓘ |
| introducedIn | .NET Framework 1.0 NERFINISHED ⓘ |
| isPartOf | ADO.NET data provider for SQL Server NERFINISHED ⓘ |
| requires | open SqlConnection for execution ⓘ |
| securityConsideration | parameterized queries help prevent SQL injection ⓘ |
| supports |
asynchronous execution
ⓘ
synchronous execution ⓘ |
| supportsCommandType |
StoredProcedure
GENERATED
ⓘ
TableDirect GENERATED ⓘ Text GENERATED ⓘ |
| threadSafety | instance members are not guaranteed to be thread-safe ⓘ |
| usedFor |
executing SQL statements
ⓘ
executing stored procedures ⓘ |
| usedWith | SQL Server database NERFINISHED ⓘ |
| uses |
SqlConnection
ⓘ
SqlParameter ⓘ SqlTransaction NERFINISHED ⓘ |
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.