SqlDataAdapter Methods

• BeginTransactionAsync Method
  Opens a SQL Server transaction scope for multiple adapter operations that must commit or roll back together.
• CreateTableValuedParameter Method
  Creates a configured SQL Server structured parameter from a POCO IDataTable.
• CreateTableValuedParameterAsync Method
  Creates a SQL Server structured parameter after loading the SQL user-defined table type schema from the database.
• CreateTableValuedParameterDataTables Method
  Converts a POCO changeset into ADO.NET DataTable objects suitable for generated SQL Server table-valued parameters.
• CreateTableValuedParameterFromSqlTypeAsync Method
  Compatibility wrapper around CreateTableValuedParameterAsync.
• DeleteAsync Method
  Executes a SQL DELETE command or a delete stored procedure and returns the number of affected rows.
• ExecuteNonQueryAsync Method
  Executes a command that does not return result sets.
• FillAsync Method
  Executes a query or stored procedure and materializes one or more result sets into a POCO IDataSet.
• FillIntoExistingDataSet Method
  Executes a query and adds the returned tables into an existing POCO IDataSet.
• FillIntoExistingDataSetAsync Method
  Asynchronously executes one or more queries and adds the returned tables into an existing POCO IDataSet.
• InsertAsync Method
  Executes a SQL INSERT command or an insert stored procedure and returns the number of affected rows.
• SaveChangesAndMergePostSaveAsync Method
  Saves a changeset and then merges post-save values back into the same POCO data set.
• SaveChangesAsync Method
  Saves Added, Modified and Deleted rows from a POCO changeset to SQL Server. It validates relations and runs inside a transaction.
• UpdateAsync Method
  Executes a SQL UPDATE command or an update stored procedure and returns the number of affected rows.

 

Table of Content POCO DataSet API References

 

---

Business Process Programming in .Net
© 2004–2026 Laskarzhevsky Software Inc.
Unless otherwise noted, the content of this website is licensed under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
Code examples are provided under the MIT License.
You are free to share and adapt the material provided that appropriate credit is given and any modifications are clearly indicated.
The information provided on this website is for educational purposes only.
The author and publisher make no warranties regarding the completeness or suitability of the information and are not responsible for any damages resulting from its use.