SqlHelperExecuteScalarAsyncT(String) Method
異步執行指令並取得第1筆資料的第1個欄位值
Namespace: eBizprise.FrameworkAssembly: eBizprise.Framework.Database.SqlHelper (in eBizprise.Framework.Database.SqlHelper.dll) Version: 25.0.3.0+6e92afb880fa099fdfe407c9aa8d1b17eaaf3625
public Task<DatabaseResult<T>> ExecuteScalarAsync<T>(
string statement
)
- statement String
- 查詢指令
- T
TaskDatabaseResultTDatabaseResult<T>
using (SqlHelper sqlHelper = new SqlHelper("SqlServer"))
{
DatabaseResult<Guid> result = sqlHelper.ExecuteScalar<Guid>(sqlHelper.GetQueryString<Employee>() + " Where IneffectiveDate Is Null Or IneffectiveDate >= GetDate()");
if (result.IsSuccess) {
Guid employeeId = result.Result;
//Do something
} else {
Exception exception = result.Exception;
//Error handling
}
}
| Date | Version | Description |
|---|
| 2020/09/28 | 1.0.21.0 | 增加異步處理機制 |
| 2025/09/19 | 25.0.0.0 | 彙整2025年度初版 |