Skip to content

Instantly share code, notes, and snippets.

@NaserKhoshfetrat
Created June 13, 2018 08:15
Show Gist options
  • Save NaserKhoshfetrat/7dd9fc6ac3f90a5070d49aad28dc5b41 to your computer and use it in GitHub Desktop.
Save NaserKhoshfetrat/7dd9fc6ac3f90a5070d49aad28dc5b41 to your computer and use it in GitHub Desktop.
c# Execute UDF scalar in sql server
public T ExecUDF_scalar<T>(string UDFName, string[] ParamNames, object[] ParamValues)
{
try
{
SqlCommand Comm = new SqlCommand();
Comm.Connection = MyConnection;
Comm.CommandText = string.Format("SELECT [dbo].[{0}] ({1}) ", UDFName, string.Join(",",ParamNames));
Comm.Parameters.Clear();
for (int i = 0; i < ParamNames.Length; i++)
Comm.Parameters.AddWithValue(ParamNames[i], ParamValues[i]);
DataSet ds = new DataSet();
MyConnection.Open();
var result = Comm.ExecuteScalar();
return (T) Convert.ChangeType(
result.ToString() , typeof(T));
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
MyConnection.Close();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment