SqlHelperExecuteProcedureScalarAsyncT(String, Object) Method
異步執行預存程序並取得第1筆資料的第1個欄位值
Namespace: eBizprise.FrameworkAssembly: eBizprise.Framework.Database.SqlHelper (in eBizprise.Framework.Database.SqlHelper.dll) Version: 25.0.2.0+adf38c4ccb2bf98d8ad258a6278302b5e05a94ed
public Task<DatabaseResult<T>> ExecuteProcedureScalarAsync<T>(
string procedureName,
Object parameter
)
- procedureName String
- 預存程序
- parameter Object
- 參數
- T
TaskDatabaseResultTDatabaseResult<T>
帶入參數名稱需與查詢式中參數名稱大小寫一致；『@』符號僅查詢式中參數名稱需前輟
using (SqlHelper sqlHelper = new SqlHelper("SqlServer"))
{
DatabaseResult<string> result = sqlHelper.ExecuteProcedureScalar<Guid>("sp_tables", new { table_name: "Employee", table_owner: "dbo", table_qualifer: "eBizprise" });
if (result.IsSuccess) {
string tableQualifier = 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年度初版 |