How can I run a scalar valued function from c# and get its value? For a table-based function, I use a select command and get the resulting DataTable, but I am clueless on how to do it with scalar valued functions.
How can I run a scalar valued function from c# and get its value? For a table-based function, I use a select command and get the resulting DataTable, but I am clueless on how to do it with scalar valued functions.
1条答案
按热度按时间dwthyt8l1#
You can pass a string to SQL and have it do anything that SQL can do using
SqlConneciton
and 'SqlCommand'.You can use ExecuteScalar or one of the other execution methods. http://msdn.microsoft.com/en-us/library/182ax5k8.aspx
You can make your SQL string do any SQL, and return/not return using the different execution methods.