我可以覆盖 SqlCommand 函数吗?
问题描述：
我有代码，例如
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