SqlHelperQueryProcedureAsyncT(String, Object) Method

public Task<DatabaseResult<IEnumerable<T>>> QueryProcedureAsync<T>(
	string procedureName,
	Object parameter
)

using (SqlHelper sqlHelper = new SqlHelper("SqlServer"))
{
    DatabaseResult<IEnumerable<TableInfo>> result = sqlHelper.QueryProcedure<TableInfo>("sp_tables", new { table_name: "Employee", table_owner: "dbo", table_qualifer: "eBizprise" });

    if (result.IsSuccess) {
        IEnumerable<TableInfo> tableInfos = result.Result;

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

        //Error handling
    }
}

// 資料表資訊
public class TableInfo
{
    // 資料庫
    public string TABLE_QUALIFIER { get; set; }
    // 擁有者
    public string TABLE_OWNER { get; set; }
    // 資料表名稱
    public string TABLE_NAME { get; set; }
    // 資料表類型
    public string TABLE_TYPE { get; set; }
}