我可以覆盖 SqlCommand 函数吗? [英] Can I override SqlCommand functions?

问题描述

我有代码，例如

Dim cmd As New SqlClient.SqlCommand(commandString, databaseString) 
Dim result As Integer

Try
    result = cmd.ExecuteScalar()
Catch e as Exception
    'catch exception code
End Try

我可以覆盖 ExecuteScalar 函数来执行某种通用异常捕获吗?

Instead of doing that, can I override the ExecuteScalar function to do some kind of generic exception catching?

推荐答案

否，但您可以创建一个通用的 DoExecuteScalar 辅助函数，该函数接受 SQL 字符串和连接字符串:

No, but you can create a generic DoExecuteScalar helper function that takes a SQL string and connection string:

Public Function DoExecuteScalar(commandString as String, databaseString as String) as Object
    Dim cmd as New SqlClient.SqlCommand(commandString, databaseString)
    Dim result as Integer
    Try
        result = cmd.ExecuteScalar()
    Catch e As Exception
        Return 0
    End Try
    Return result
End Function

这篇关于我可以覆盖 SqlCommand 函数吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！