SqlHelperExecuteProcedureReader(String) Method

執行預存程序並取得讀取器

Definition

Namespace: eBizprise.Framework
Assembly: eBizprise.Framework.Database.SqlHelper (in eBizprise.Framework.Database.SqlHelper.dll) Version: 25.0.2.0+adf38c4ccb2bf98d8ad258a6278302b5e05a94ed
C#
public DatabaseResult<IDataReader> ExecuteProcedureReader(
	string procedureName
)

Parameters

procedureName  String
預存程序

Return Value

DatabaseResultIDataReader
DatabaseResult<IDataReader>

Implements

IDatabaseHelperExecuteProcedureReader(String)

Example

C#
using (SqlHelper sqlHelper = new SqlHelper("SqlServer"))
{
    DatabaseResult<IDataReader> result = sqlHelper.ExecuteProcedureReader("sp_tables");

    if (result.IsSuccess) {
        IDataReader dataReader = result.Result;

        //Do something
    } else {
        Exception exception = result.Exception;

        //Error handling
    }
}

Revision History

DateVersionDescription
2020/02/071.0.0.0初版
2020/02/191.0.0.1調整回傳格式包含執行成功與否以及異常訊息
2025/09/1925.0.0.0彙整2025年度初版

See Also