这是一个快速的VB.NET示例.

Using conn = IDbConnectionFactory.CreateFromProvider("System.Data.sqlClient",CONNECTION_STRING)
                Dim sqlCommand As String = "SELECT dbo.fx_SumTwoValues(@valueOne,@valueTwo) As SumOfTwoValues"
                conn.Open()
                Dim result = (conn.Query(Of Integer)(sqlCommand,New With {.valueOne = 1,.valueTwo = 2})).First()
                Console.WriteLine(result.ToString)
            End Using

这是我在我连接中使用的同一个数据库上创建的函数.

CREATE FUNCTION fx_SumTwoValues
( @Val1 int,@Val2 int )
RETURNS int
AS
BEGIN
  RETURN (@Val1+@Val2)
END
GO