SqlHelperUpdateT(T) Method
更新
Namespace: eBizprise.FrameworkAssembly: eBizprise.Framework.Database.SqlHelper (in eBizprise.Framework.Database.SqlHelper.dll) Version: 25.0.2.0+adf38c4ccb2bf98d8ad258a6278302b5e05a94ed
public DatabaseResult<int> Update<T>(
params T[] updateObjects
)
- updateObjects T
- 更新物件
- T
- 物件類型
DatabaseResultInt32DatabaseResult<int>
IDatabaseHelperUpdateT(T) 更新時主要依據主鍵進行更新
using (SqlHelper sqlHelper = new SqlHelper("SqlServer"))
{
List<Employee> employees = new List<Employee>();
employees.Add(new Employee() { Account = "Test1", EmployeeId = Guid.NewGuid(), EmployeeNo = "0001", EffectiveDate = DateTime.Now });
employees.Add(new Employee() { Account = "Test2", EmployeeId = Guid.NewGuid(), EmployeeNo = "0002", EffectiveDate = DateTime.Now });
employees.Add(new Employee() { Account = "Test3", EmployeeId = Guid.NewGuid(), EmployeeNo = "0003", EffectiveDate = DateTime.Now });
DatabaseResult<int> result = sqlHelper.Update<Employee>(emploees.ToArray());
if (result.IsSuccess) {
int effectRow = result.Result;
//Do something
} else {
Exception exception = result.Exception;
//Error handling
}
}
| Date | Version | Description |
|---|
| 2020/02/07 | 1.0.0.0 | 初版 |
| 2020/02/19 | 1.0.0.1 | 調整回傳格式包含執行成功與否以及異常訊息 |
| 2020/03/06 | 1.0.2.0 | 增加支援結構描述 |
| 2020/09/01 | 1.0.18.0 | 增加Log明細 |
| 2025/08/08 | 1.0.1.0 | 修正含ExtendJson資料查詢會變空值問題 |
| 2025/09/19 | 25.0.0.0 | 彙整2025年度初版 |