SaveChangesAndMergePostSaveAsync Method

Overview

The SaveChangesAndMergePostSaveAsync method saves a changeset and then merges post-save values back into the same POCO data set.

Declarations

/// <summary>
/// Saves data set changes to SQL Server and merges post-save values.
/// </summary>
public async Task<int> SaveChangesAndMergePostSaveAsync(IDataSet changeset, string? connectionString = null)

/// <summary>
/// Saves data set changes to SQL Server using the requested save options and merges post-save values.
/// </summary>
public async Task<int> SaveChangesAndMergePostSaveAsync(IDataSet changeset, SqlDataAdapterOptions? options, string? connectionString = null)

Namespace and Assembly

Namespace: PocoDataSet.SqlServerDataAdapter
Assembly: PocoDataSet.SqlServerDataAdapter.dll

Usage Example

IDataSet dataSet = DataSetFactory.CreateDataSet();
IDataTable table = dataSet.AddNewTable("HostedApplicationLayer");
table.AddColumn("DomainName", DataTypeNames.STRING);
table.AddColumn("UseCaseName", DataTypeNames.STRING);
table.AddColumn("ApplicationLayerName", DataTypeNames.STRING);
table.AddColumn("Url", DataTypeNames.STRING);

IDataRow row = table.AddNewRow();
row["DomainName"] = "HR";
row["UseCaseName"] = "Accounting";
row["ApplicationLayerName"] = "DAL";
row["Url"] = "http://localhost:5075";

SqlDataAdapterOptions options = new SqlDataAdapterOptions();
options.SaveMode = SqlSaveMode.RowByRow;

SqlDataAdapter adapter = new SqlDataAdapter(connectionString);

int affectedRows = await adapter.SaveChangesAndMergePostSaveAsync(dataSet, options, null).ConfigureAwait(false);

// The same dataSet now contains post-save values produced by the save operation.

 

Table of Content POCO DataSet API References SqlDataAdapter Members

 

---

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.