SqlDataAdapter
E827341
SqlDataAdapter is an ADO.NET component that acts as a bridge between a SQL Server database and a DataSet, handling the retrieval and updating of data without requiring explicit connection management in application code.
Statements (45)
| Predicate | Object |
|---|---|
| instanceOf |
ADO.NET component
ⓘ
bridge between SQL Server and DataSet ⓘ data adapter ⓘ |
| belongsToAssembly | System.Data.dll NERFINISHED ⓘ |
| canBeUsedFor |
batch updates
ⓘ
mapping database columns to DataSet columns ⓘ optimistic concurrency control via commands ⓘ |
| category | data access technology ⓘ |
| compatibleWith | SQL Server database NERFINISHED ⓘ |
| constructorOverload |
SqlDataAdapter()
NERFINISHED
ⓘ
SqlDataAdapter(SqlCommand) NERFINISHED ⓘ SqlDataAdapter(string selectCommandText, SqlConnection selectConnection) ⓘ SqlDataAdapter(string selectCommandText, string selectConnectionString) ⓘ |
| definedIn |
.NET 5+
NERFINISHED
ⓘ
.NET Core NERFINISHED ⓘ .NET Framework NERFINISHED ⓘ |
| developedBy | Microsoft ⓘ |
| hasMethod |
Dispose
ⓘ
Fill ⓘ FillSchema ⓘ GetFillParameters ⓘ ResetFillLoadOption ⓘ Update ⓘ |
| hasProperty |
DeleteCommand
ⓘ
InsertCommand ⓘ SelectCommand ⓘ TableMappings ⓘ UpdateCommand ⓘ |
| inheritsFrom | DbDataAdapter NERFINISHED ⓘ |
| manages |
closing connections implicitly during Fill
ⓘ
closing connections implicitly during Update ⓘ opening connections implicitly during Fill ⓘ opening connections implicitly during Update ⓘ |
| oftenUsedWith | SqlCommandBuilder NERFINISHED ⓘ |
| partOf | System.Data.SqlClient namespace NERFINISHED ⓘ |
| supports |
disconnected data access
ⓘ
fill DataSet from SQL Server ⓘ update SQL Server from DataSet ⓘ |
| threadSafety |
instance members are not guaranteed to be thread safe
ⓘ
static members are thread safe ⓘ |
| usedWith |
DataSet
ⓘ
DataTable ⓘ SqlCommand NERFINISHED ⓘ SqlConnection NERFINISHED ⓘ |
| uses | TDS protocol via SqlClient provider ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.