如何调用从ado.net一个TSQL功能 [英] How do I call a TSQL function from ado.net

问题描述

我在SQL Server中定义的函数（即需要一个字符串和INT）我怎么把它使用ADO.NET？

I have a function defined in SQL Server (that takes a string and a int) how do I call it with ADO.NET?

（如果是100％相同，调用存储过程，请大家这么说，因为在调用存储的特效讲了很多例子）

(If it is 100% same as calling a stored proc, please just say so, as there a lot of examples on calling stored procs about)

推荐答案

唯一的区别是，你必须有一个特殊的放慢参数添加返回值

The only difference is that you must have a special paramter added for the return value

请参阅：<一href="http://stackoverflow.com/questions/3080940/mysqlcommand-call-function/3081005#3081005">MySqlCommand调用函数

  using (var connection = new SqlConnection("ConnectionString"))
  using (var command = connection.CreateCommand())
  {
    command.CommandType = CommandType.StoredProcedure;
    command.CommandText = "MyFunction";

    SqlParameter returnValue = command.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
    returnValue.Direction = ParameterDirection.ReturnValue;

    connection.Open();
    command.ExecuteNonQuery();

    return returnValue.Value;
  } 

这篇关于如何调用从ado.net一个TSQL功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！